Relational database
Write the SQL query for each of the following tasks 1. Find all clients who are located in the city Austin. Include the Client Number, Client Name, and City in the query result 2. Find all clients located in North Carolina(NC) with an amount paid grearter than $3,000.00. Include the Client Number, Client Name, and Amount Paid fields in the query result. Find all clients whose names begin with the letter W. Include the Client Number, Client Name, and City fields in the query result. 4. List all cities in descending order. Each city should appear only once. 5. Display the Client Number, Client Name, Service Rep Number, First Name and Last Name for all clients. Sort the result in ascending order by service rep number and then by client number 6. List the average of Balance Due amount grouped by Service Rep Number. Name the average of Balance Due as Average Balance. Sort the result in ascending order by service rep number. Find the Client Number, Client Name, and City for every pair of clients who are located in the same city. No repeating pairs are allowed Find the Client Number, Client Name, and Service Rep Number for all clients that have service requests. Use the alias S for the Service Requests table and C for the Client table. Each client should appear only once in the result 7. 8. 9. Use a subquery to find all service reps whose clients are located in Georgetown. 10. Find the average balance due amount for service rep 52. Include the Service Rep Number, First Name, and Last Name in the query result Write the SQL query for each of the following tasks 1. Find all clients who are located in the city Austin. Include the Client Number, Client Name, and City in the query result 2. Find all clients located in North Carolina(NC) with an amount paid grearter than $3,000.00. Include the Client Number, Client Name, and Amount Paid fields in the query result. Find all clients whose names begin with the letter W. Include the Client Number, Client Name, and City fields in the query result. 4. List all cities in descending order. Each city should appear only once. 5. Display the Client Number, Client Name, Service Rep Number, First Name and Last Name for all clients. Sort the result in ascending order by service rep number and then by client number 6. List the average of Balance Due amount grouped by Service Rep Number. Name the average of Balance Due as Average Balance. Sort the result in ascending order by service rep number. Find the Client Number, Client Name, and City for every pair of clients who are located in the same city. No repeating pairs are allowed Find the Client Number, Client Name, and Service Rep Number for all clients that have service requests. Use the alias S for the Service Requests table and C for the Client table. Each client should appear only once in the result 7. 8. 9. Use a subquery to find all service reps whose clients are located in Georgetown. 10. Find the average balance due amount for service rep 52. Include the Service Rep Number, First Name, and Last Name in the query result
