ITEMS SK V4B1 C87A6E5 J3K6A8V1Fear: Trump in the White House P4F5B2N6 T8G4F4A0A

Question

ITEMS SK V4B1 C87A6E5 J3K6A8V1Fear: Trump in the White House P4F5B2N6 T8G4F4A0A Dance with Dragons Name UnitPrice sign Drawing ndamenta Database Systems 65.99 39.99 24.06 13.50 rn a Crime: Stories from a South African Childho CUSTOMERS CutomerID Name 102 512 Sara Allain D'Entremont 982 Anonymous Resident DDRESSES AddressID Street 984 2843 City Montgomery Province Country PostalCode nited States 34243 ny 1a 10456 Young Street Halifax 1823 Prospect Street Wolfvill 24 Sussex Drive 1234 East 57th StreetNew York Nova Scotia Nova Scotia Ontario New Yok United States 45019 3A9 B4P 7Y4 K1M 1M4 Ottawa 9472 ORDERS OrderID Date Customer Address Sep 7, 2018 102 Sep 11, 2018 512 10, 2018 982 Sep 7, 2018 167 Sep 10, 2018 512 Mar 21, 2018 102 780 984 2843 9472 1231 780 ER ITE OrderID SKU Qty Unit Charge 44.97 28.99 13.50 65.99 39.99 65.99 24.06 13.50 V4BIC8D3 1 T8G4FAA0 1 C87A6E54 3K6A8V1 C87A6E54 P4F5B2N6 T8G4FAA0 1 50 C87A6E54 11.99

Explanation / Answer

Solution :

a)
Select * from ORDER_ITEMS where Qty > 1

B)
Select SKU as ID, Qty
from ORDER_ITEMS
where Qty > 1

c)
select Sum(Qty)
from ORDER_ITEMS
group by SKU

d)
select * from
Province as p
inner join
inst as i
on p.prov_cd = i.prov_cd

e)
select instname as org, en_name as prov_eng, fr_name as prov_fr
from province as p
inner join
inst as i
on p.prov_cd = i.prov_cd

if you have any doubts then you can ask in comment section if you find the solution helpful then upvote the answer. Thank you.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

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