Need help with the line with red text: Photos- Untitled jpg See all photos a?2 ?

Question

Need help with the line with red text:

Photos- Untitled jpg See all photos a?2 ?Share Add to a creation Edit & Create . Worksheet Query Builder PROM employee: -You should try to run your script before you turn it in. Open the file in the Oracle soL developer and run as one script You ight want to DROP TABLE to be able to test the CREATE TABLE statements TASK B.2 --Create the USER table Create table user (ID varchar2 (10) prinary key,firstname varchar2 (10), lastname varchar2 (10),memberdate timestamp, userlanguage varchar2 (10),usertype varchar2 (10), emailid varc --Create the GIG table create table gig(gigcode int,freelancerid int, ticle varchar2 (5), Irage varchar2 (10), category varchar2 (10), servicedelivery tinestamp,projectdescription varchar2 (10),primary ke Create the GIG PACKAGE table Need this one please -Create the ORDER table create table order (orderid int, ordertype varchar2 (10), odate date,otime time, ordeztotal int,status varchar2 (10),deliverytime timestamp, ordertracking varchar2 (10),primary key -Create the TRANSACTION table create table transaction (eransactiondate tinestamp, anount int primary key, paymentmethod varchar2 (10), remainingbalance int, orderid int, ordertracking varchar2 (10),primary ke --Create the MESSAGES table create table comunication (orderid int,communicationdatetime timestamp,message varchar2 (10), attachment varchar2 (10), orderidl int, ordertracking varchar2 (10), freelancerid int :--Create the GIG RATING table. TASK B.3-Insert at least two rows in each table TASK B.4 --Query B.4.a. For each gig, the number of ratings and average star rating SELECT GidCode, Title, COUNT () NUMBER_OF RATINGS, AVG(Rating) AVG RATING PROM Gig G INNER JOIN Freelancers FON F.FreelancerID G.FreelancezID GROUP BY G.GigCode, Title: -Query B.4.b. For each gig package, the price and the total money earned with it --Query B.4.c. For each client, the total number of orders placed and the total amount spent on thm. (This does not include received for work done as a freelancer.) Query B.4.d. For each freelancer, the total number of gigs completed for clients and total amount earned from them SELECT FreelancerID, COUNT ( NUMBER OF_GIGS, SUM (AMOUNI) TOTAL AMOUNI FROM Gig G, Gigorders GO, orders o, Transaction WHERE G.GigCode GO.GigCode AND GO.OrderID-o.orderID AND O.OrderID·T·OrderID AND Status = 'Cozpleted GROUP BI FreelancerID Query B.4.e. For each gig category, the total number of orders and the total amount (G) earned/spent on them. 0 Type here to search 8:15 AM 4/29/2018

Explanation / Answer

If you have any doubts, please give me comment...

SELECT GigPackage(
    GigCode INT,
    OrderID INT,
    PRIMARY KEY(GigCode, OrderID)
);

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.