Part A. Please go to the following URL and complete the tasks listed below:
https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_all
1. 2. 3. 4.
5.
Part B. 1.
2.
3. 4.
Part C.
Find the number of suppliers for each of the product category
Find the total price for each order, sort them based on price in descending order
Find the category name and description for each product in Table Products
Find the EmployeeID who has the highest order amount (e.g. the total dollar amount for an order) in July 1996
Find the top three countries where consumers purchased the most (e.g. the total dollar amount for all orders placed for goods originated from a country) in all periods
Use the music instrument database and retrieve the following information
Find all instruments that producers of albums with album_ids in the set S={30,40,50} play. Sort the results by instrument description in ascending order and remove any duplicates.
Find the names, ids, song ids and album ids of all musicians that participated in album with album_id = 30. Sort them in decreasing order by musician_id.
Find the states of producers.
Find the description of instruments with ids 1,2,3 and all the states of the producers.
Use the Stackoverflow Data Explorer to retrieve the following information:
https://data.stackexchange.com/stackoverflow/query/new
1. Find the top 200 questions with most views in 2019 February (Note: Questions are posts with PostTypeId =1).
2. Find the # Questions that contain either tag ¡°python¡± or ¡°javascript¡± (Note: We cant use COUNT to count each tag individually as Tag represents a list of tags in same string. So you may use LIKE.)
3. Find the # Questions that contain either tag ¡°python¡± or ¡°javascript¡± per month in 2019 January and February.