1) What results will be produced by execution of following query? SELECT c.CustName FROM Customer c WHERE c.CustCNIC LIKE ‘35201-%-0’; 2) What is the difference between these two queries A and B? Will they both produce same result or not? And Why? (A) SELECT AVG(p.ProdPrice) FROM Product p; (B) SELECT AVG(DISTINCT p.ProdPrice) FROM Product p; 3) Write a SQL query to show how many orders of amount more than 1000 are placed in the month of August 2021.
Following tables support the
Customer, Product, Order and Order Product. Table details including attributes, primary keys
(underline) and foreign keys (bold) are also shown below:
CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)
PRODUCT(ProdID, ProdName, ProdPrice)
ORDER(OrderID, OrderDate, OrderPrice, CustID)
ORDER_PRODUCT(OPID, ProdID, OrderID)
1) What results will be produced by execution of following query?
SELECT c.CustName FROM Customer c WHERE c.CustCNIC LIKE ‘35201-%-0’;
2) What is the difference between these two queries A and B? Will they both produce same result or not? And Why?
(A) SELECT AVG(p.ProdPrice) FROM Product p;
(B) SELECT AVG(DISTINCT p.ProdPrice) FROM Product p;
3) Write a SQL query to show how many orders of amount more than 1000 are placed in the month of August 2021.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
