Discuss the below:
Q1: Write SQL queries
Write a SQL query that joins Customer and Store table in the Kudler database and uses BETWEEN to restrict record selection (use Store Name to restrict the data).
Write a SQL query that Customer and Store table in the Kudler database and uses LIKE to restrict record selection (use Store Phone Number to restrict data).
Group Customers by Store Name: Select the Customer's last name and group them by Store Name.
Choose a Customer from the Customer table, delete this Customer.
Calculate the maximum labor cost for all item types from the Item Table.
Q2: In addition create your own SQL query illustrating
• GROUP statement
• UNION statement
• JOIN statement
• INSERT statement
• DELETE/DROP statement
Attachment:- Diagram of db.rar