SoftUni-CSharp-DB My solutions to SoftUni's DB problems: MS SQL Entity Framework Core Databases Introduction Create Database Create Tables Alter Minions Table Insert Records in Both Tables Truncate Table Minions Drop All Tables Create Table People Create Table Users Change Primary Key Add Check Constraint Set Default Value of a Field Set Unique Field Movies Database Car Rental Database Hotel Database Create SoftUni Database Basic Insert Basic Select All Fields Basic Select All Fields and Order Them Basic Select Some Fields Increase Employees Salary Decrease Tax Rate CRUD Find All Information About Departments Find all Department Names Find Salary of Each Employee Find Full Name of Each Employee Find Email Address of Each Employee Find All Different Employee’s Salaries Find all Information About Employees Find Names of All Employees by Salary in Range Find Names of All Employees Find All Employees Without Manager Find All Employees with Salary More Than 50000 Find 5 Best Paid Employees Find All Employees Except Marketing Sort Employees Table Create View Employees with Salaries Create View Employees with Job Titles Distinct Job Titles Find First 10 Started Projects Last 7 Hired Employees Increase Salaries All Mountain Peaks Biggest Countries by Population Countries and Currency (Euro / Not Euro) All Diablo Characters Table Relations One-To-One Relationship One-To-Many Relationship Many-To-Many Relationship Self-Referencing Online Store Database University Database Peaks in Rila Built-in Functions Find Names of All Employees by First Name Find Names of All employees by Last Name Find First Names of All Employees Find All Employees Except Engineers Find Towns with Name Length Find Towns Starting With Find Towns Not Starting With Create View Employees Hired After 2000 Year Length of Last Name Rank Employees by Salary Find All Employees with Rank 2 * Countries Holding ‘A’ 3 or More Times Mix of Peak and River Names Games from 2011 and 2012 year User Email Providers Get Users with IPAdress Like Pattern Show All Games with Duration and Part of the Day Orders Table People Table Subqueries and Joins Employee Address Addresses with Towns Sales Employee Employee Departments Employees Without Project Employees Hired After Employees with Project Employee 24 Employee Manager Employee Summary Min Average Salary Highest Peaks in Bulgaria Count Mountain Ranges Countries with Rivers Continents and Currencies Countries Without Any Mountains Highest Peak and Longest River by Country Highest Peak Name and Elevation by Country Indices and Data Aggregation Records’ Count Longest Magic Wand Longest Magic Wand Per Deposit Groups Smallest Deposit Group Per Magic Wand Size Deposits Sum Deposits Sum for Ollivander Family Deposits Filter Deposit Charge Age Groups First Letter Average Interest Rich Wizard, Poor Wizard Departments Total Salaries Employees Minimum Salaries Employees Average Salaries Employees Maximum Salaries Employees Count Salaries 3rd Highest Salary Salary Challenge Functions and Stored Procedures Employees with Salary Above 35000 Employees with Salary Above Number Town Names Starting With Employees from Town Salary Level Function Employees by Salary Level Define Function Delete Employees and Departments Find Full Name People with Balance Higher Than Future Value Function Calculating Interest Scalar Function: Cash in User Games Odd Rows Triggers and Transactions Entity Framework Introduction Employees Full Information Employees with Salary Over 50 000 Employees from Research and Development Adding a New Address and Updating Employee Employees and Projects Addresses by Town Employee 147 Departments with More Than 5 Employees Find Latest 10 Projects Increase Salaries Find Employees by First Name Starting with "Sa" Delete Project by Id Remove Town Entity Relations Student System Football Betting LINQ MusicHub Database Albums Info Songs Above Duration Advanced Querying Age Restriction Golden Books Books by Price Not Released in Book Titles by Category Released Before Date Author Search Book Search Book Search by Author Count Books Total Book Copies Profit by Category Most Recent Books Increase Prices Remove Books JavaScript Object Notation - JSON Import Users Import Products Import Categories Import Categories and Products Export Products In Range Export Sold Products Export Categories By Products Count Export Users and Products Import Suppliers Import Parts Import Cars Import Customers Import Sales Export Ordered Customers Export Cars From Make Toyota Export Local Suppliers Export Cars With Their List Of Parts Export Total Sales By Customer Export Sales With Applied Discount Extensible Markup Language - XML Import Users Import Products Import Categories Import Categories and Products Export Products In Range Export Sold Products Export Categories By Products Count Export Users and Products Import Suppliers Import Parts Import Cars Import Customers Import Sales Export Cars With Distance Export Cars From Make BMW Export Local Suppliers Export Cars With Their List Of Parts Export Total Sales By Customer Export Sales With Applied Discount Code-First Hospital Database Hospital Database Modification Sales Database 4-5. Migrations