Need help with the query request in red

Oracle SQL Developer File Edit Virw Navigate Run Source Team Iools Window Help sktopuSQ4 3310 Final Project Aughesq 4 3310Fil Project.so Start Page 5Ql Workshoet Hstory monina ISQA 3310 Fina Praject Aughe.sq iarkaheet Query Euider ou ahoald try to run your acript beftore goa turn 1t in. Open the rile in the Oracle soL developer and run as one acript. You night want to DROP TABLE to be able to test the CREATE TABLE statemencs TASK B.2 -Create the USER table. create table use? ?ID varchar2(10) primary key, firstnane varchar2 LO),Lestnane varchar2(10),mer berdate timestamp, userlanguage varchar2(10) usertype varchar2(L0) enslid varchar2(20),password varchar2(10 --Create the GIG table. create tabie gig(g1gcode int,freelancerid int, titie varchar (5), Image varchar2 (10), category varcharz (10),aervicedlivery timestamp,projectdcacription varchar2 (10),prinary ke (gigcode,Ireelancerid), foreig -Create the GIG PACKAGE tble Create the ORDER table create table order oreerid int,ordertype varcar2 (10),odate date,otine tine, ordertotal int,status varchar2(10),deliverytine timestaup, ordertracking varchar2410), prinary key (orderid,ordertracking), oreic Create the TRANSACTTOT abie. create table transactiontransactiondate tinestamp, emount int prinary keg, paynentmethod varchar2(10), remainingbalance int,orderid int, ordertracking varchar2(10 prinary kes (enount, orderid, ordertracking -Ceate the MESSAGEs cabie create table comrunicacion (orderid int,comrunicaciondatetine timestamp,nessage varcharz[LO),actachment varchar2 (10,orderidi int,ordercracking varcharz(10),treelancerid int, prinary e (ordertrackirg,r --Ceate the GIG RATING tabl Need Help with this query code :--TASK B.3 -- Insert at least two rows TASK B. -Query B.4.a. For each gig, the number of ratings and average star rating sSLECT GidCode, Title, COUNT(*) NUMBER OF RATINGS, AVS(Rating) AVG RATING GROOP e.GigCode, Title; -Query B.4. For each gig package, the price and the total noney earned with 1t. :-. Query B. 4.c For each client, the total number of order? placed and the total anount spent on them. ?ThLB does not include ceceived for wor done as a reelancer. :-. Query B.4.d For each freelancer, the total number of gigs completed for clients and total arount earned from then. SELECT ?reelancerID, OOUNT(*> m2EER OF GIGS, SUM?AMOUNT? TOTAL AMOUNT rant G1g Gr Gladrder, Go, orders o, Transaction WHERE G.G?gCode = GO,GigCode aid GO.Order1D = ?.OrderID aid ?.OrderID = T.OrderID AND Status = 'Completed' GROUP BY FreelancerID :-. Query B. 4.e for eacn gig Category, the total number of order5 and the total amount earned/spent on then. Saved: CVWsers'ycaugh'Desktop TSQA 3310 Final Profect Aughe.sol O Type here to seardh B24 AM 4/29/2018