Identify the attributes that you want to display (i.e., in a SELECT clause) Identify the tables that
Question:
- Identify the attributes that you want to display (i.e., in a SELECT clause)
- Identify the tables that contain these attributes (try out the tables in Azure Data Studio by using SELECT * )
- Find the column that is common between the two tables.
- Write the query connecting the two tables using the common column.
1) Display the Name of the Product and the corresponding name of the supplier of that Product.
(Hint: Products and Suppliers table)
2) Write a query to display the name of the product and the quantity of the Orders of that product. It is OK to display the product name multiple times if the product has been ordered multiple times (i.e., don't have to use GROUP BY)
3) Write a query to display the Shipper's name and Order Date when the order was placed. It is OK to display the Shipper's name multiple times if the order is placed more than once using the shipper.
4) Display the firstname, lastname of the employees and the customerID that the employee served. Arrange the results by the last name.
5) Write a query to the Name of the Product and the corresponding name of the supplier of that Product for all the products that start with a "P".
6) Write a SQL query to output the product name and the quantity of the Orders of that product for those orders with more than 70 quantity. (hint: don't have to use GROUP BY)
7) Write a query to display Unique order dates from the shipper named "Speedy Express".
8) Display the firstname, lastname of the employees and the customerID that the employee served such that the employees are born after '1960-01-01'. Arrange the results by the last name.