Question 3 10 Pts I Orders Snum Snum Onum Int 4 Odate Date Cnum Int 4 Snum Int 4 City Varchar 10 Indexes Salespeople 1 (56.47 KiB) Viewed 74 times
Question 3 10 pts I orders Snum Snum Onum INT(4) Odate DATE Cnum INT(4) Snum INT(4) City VARCHAR(10) Indexes salespeople Snum INT(4) Sname VARCHAR(10) City VARCHAR(10) Comm FLOAT(3,2) Indexes Snum Snum # Onum Onum Cnum Cnum orderItems Onum INT (4) Fnum INT (4) Quantity INT(4) Indexes O customers Cnum INT(4) Cname VARCHAR(10) +City VARCHAR(10) Rating INT(11) Snum INT(4) Indexes Fnum Fnum fruits Fnum INT (4) Fname VARCHAR(10) Vnum Vnum Ftype VARCHAR(4) Fprice FLOAT (6,2) Vnum INT(4) vendors Vnum INT(4) Vnam e VARCHAR(10) City VARCHAR(10) Comm FLOAT (3,2) -
Onum onum Cnum Cnum order Items Onum INT (4) Fnum INT(4) Quantity INT(4) Indexes customers Cnum INT(4) Cname VARCHAR(10) +- City VARCHAR(10) Rating INT(11) Snum INT(4) Indexes Fnum Fnum vendors fruits Fnum INT (4) Fname VARCHAR(10) Vnum Vnum Ftype VARCHAR(4) Fprice FLOAT(6,2) Vnum INT(4) Indexes Vnum INT(4) Vnam e VARCHAR(10) City VARCHAR(10) Comm FLOAT(3,2) Indexes Using FruitsTrading DB, write SQL query to list customers (Cnum, Cname), who have ordered (as total amount in USD) more STS than LTS type of fruits. Edit View Insert Format Tools Table 12pt v Paragraph Β Ι Ο A V o T² ***
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!