1. Is Not Null Values operator: Go to the webpage: https://www.w3schools.com/sql/trysql.asp?filename=trysql_is_nullLinks to an external site. Instead of trying to determine if any records in the Customers database are missing Address information, you want to check the Products database, then find out if any records are missing ProductID data [Hint: After the SELECT command, add the * symbol]. How many of the 77 records in the Products database are missing ProductID data?
2. Min operator:Go to the webpage: https://www.w3schools.com/sql/trysql.asp?filename=trysql_is_not_nullLinks to an external site. Instead of determining the minimum price from the Products database, you want to determine the smallest order quantity from the OrderDetails database. What is the smallest order quantity from the OrderDetails database?
3. Max operator: Go to the webpage: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_maxLinks to an external site. Instead of determining the maximum price from the Products database, you want to determine the maximum largest order quantity from the OrderDetails database. What is the largest order quantity from the OrderDetails database?
4. Average operator: Go to the webpage: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_avg Links to an external site.Instead of finding the average price of products in the Product database, What is the average Quantity of all order in the OrderDetails database?
5. Count operator: Go to the webpage: https://www.w3schools.com/sql/trysql.asp?filename=trysql_select_countLinks to an external site. Instead of counting the number of records with a ProductID from the Products database, count the number of records in the Customers database which list the city of London. Hint: change ProductID to CustomerName and add a WHERE(City)='London' statement at the end of the command.