MySQL Essays

Here are two sets of data:

Q1:

Data Set #1PERSONTop5_1Top5_2Top5_3Top5_4Top5_5PhilipSeptemberSuperstitionSuper FreakRock SteadyFlashlightJelloRiotAnarchyLabotomyTV PartyLast CaressRobertBlack DogI Feel FineSatisfactionBack In BlackPurple HazeNoelleWonderwallCreepEverlongScatteredGigantorDebbieSunday GirlCarsChristineTemptationWhip ItFlorianOperatorCinemaTitaniumFirestarterTsunamiPatsyAfter MidnightWalk The LineJoleneBreatheFancy

Data Set #2PERSONTop5_1Top5_2Top5_3Top5_4Top5_5JohhnyBlitzkrieg BopRise AbovePunk Rock GirlInstitutionalizedBasket CaseRobertBlack DogI Feel FineSatisfactionBack In BlackPurple HazePhilipSeptemberSuperstitionSuper FreakRock SteadyFlashlightNoelleWonderwallCreepEverlongScatteredGigantorSiouxsieKiss ThemTake On MeRock LobsterLove My WayTainted LovePatsyAfter MidnightWalk The LineJoleneBreatheFancyJelloRiotAnarchyLabotomyTV PartyLast Caress

Perform the following set operations using the above data sets:

1. Intersection of Data Set #1 and Data Set #2

2. Difference (Data Set #2 minus Data Set #1)

3. Union of Data Set #1 and Data Set #2

Q2:SalesOrdersExample database
Display the list of products by the order they are included in along with the category they belong to and their retail price.
Order the list by the category they are in along with the retail price in descending order.
(Hint: The solution requires a JOIN of four tables)
Show your SQL code below:

Q3:

SalesOrdersExample database

List employees and the customers for whom they booked an order
(Hint: The solution requires a JOIN of more than two tables)
Show your SQL code below:

Q4:

EntertainmentAgencyExample database
Find the agents and entertainers who live in the same postal code
(Hint: The solution requires a JOIN on matching values)
Show your SQL code below:

Q5:

RecipesExample database
List all recipes that contain a dairy ingredient
(Hint: The solution requires a JOIN of four tables)
Show your SQL code below: