Write Each Prompt in Sql

1.) List client number, name, and balance of all clients with a balance greater than the maximum balance of all clients whose name contains the word 'Shop' or 'Boutique'.

2.) List client name, credit limit, consultant number, and consultant last name of every client who has a higher credit limit than that of a client named 'Market Sales.'

3.) List order number, order date, client name, and client city of all orders placed NOT on the same date as order number '62638.'

4.) List consultant last name, count of clients, and average balance of all clients for each consultant.

5.) List order date and count of work orders on each date, for orders placed by clients from all cities OTHER THAN 'Bristol.'