Make a SQL query based on the picture below:

Query: Create a view for each of the queries in B.4 (This is the question)

B.4 Reference Screenshot(Down below is the screen shot, the above query about B.4 is based on the questions below which I have on Chegg separately.)

Photos 84PNG See all photosAdd to a creaticn X Edit & Create? ?Share B4 Image Is This 4. Create queries that show 1. For each gig, the number of ratings and average star rating. 2. For each gig package, the price and the total money earned with it. 3. For each client, the total number of orders placed and the total amount spent on them. (This does not include money received for work done as a freelancer.) 4. For each freelancer, the total number of gigs completed for clients and total amount earned from them. 5. For each gig category, the total number of orders and the total amount ($) earned/spent on them. OType here to search 9:58 FM 4/29/2018 Photos 84PNG See all photosAdd to a creaticn X Edit & Create? ?Share B4 Image Is This 4. Create queries that show 1. For each gig, the number of ratings and average star rating. 2. For each gig package, the price and the total money earned with it. 3. For each client, the total number of orders placed and the total amount spent on them. (This does not include money received for work done as a freelancer.) 4. For each freelancer, the total number of gigs completed for clients and total amount earned from them. 5. For each gig category, the total number of orders and the total amount ($) earned/spent on them. OType here to search 9:58 FM 4/29/2018