IT234_Jose Gonzalez_Unit6

docx

School

Purdue Global University *

*We aren’t endorsed by this school

Course

163

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

6

Uploaded by ConstableQuailMaster1160

Report
SQLQuery.sql - DE..UHTATTEVose (5T)* & X rthwindDa...UHT4] Sluse Northwind; Sselect * from Products where UnitPrice >-100; 100% ~. FE Resuts G Messages Productame SupplerlD CategorylD QuantiyPed UnitPice UnitsinStock UntsOnOrder Reorderlevel Discontinued I Thiringer Rostbratwurst 12 6 50bags x 30 sausgs. 12379 o 0 o 1 2 Céte de Blaye 18 1 12-75clbotles 26350 17 0 15 0 SQLQuery1.sql - DE..UHTAT/EVose (57" = X Sluse Northwind: Siselect Discontinued, min(UnitPrice) as ‘minimum unit price’, max(UnitPrice) as ‘maximum unit price’, avg(UnitPrice) as ‘average unit price’, stdev(UnitPrice) as 'unit price standard deviation’ from Products group by Discontinued 0% - BB Resuts il Messages Discontinued _ minmum unk pice maxinum unk pice average und price unk pice standard deviaton 1 [8 ] 250 %350 %743 32.464315951983 2 1 450 127 7255 7765422900733 I @ Query executed successfully. DESKTOP-UHTAT/E\SQLEXPRESS ... DESKTOP-UHT4T7Eose (57) Northwind 00:00:00 2 rows
5QLQueryT.sql - DE..UHTATTEVose (7)) & X Suse Northwind; S select Companyliame From Suppliers WHERE UPPER (CompanyName) 1ike 'G¥' | | order by Companyliame; 00% - BB Resuts g Messages CompanyMame 1 [Gaiphiuage 2 Gy, Mate 3 Grandna Kely's Homestead © Query executed successiuly. DESKTOP-UHTATTE\SQLEXPRESS .. DESKTOP-UHTATTEVose (57) Northwind | 00:0000 | 3 rows SQLQueryl.sql - DE..UHTATEVose (57))* + X UHTAT7EVose (56)) “luse Northwind; Gselect Firstliame + ' ' + LastName as 'Enployee Name' - from Employees; 13 e Loverog |4 Margaret Peacock. |5 Steven Buchanan |6 Mchael Suyama |7 Robetking |8 LaaCatean |9 Amme Dodsworth @ Query executed successfully. DESKTOP-UHTAT7E\SQLEXPRESS ... DESKTOP-UHTAT7EVose (57) Northwind | 00:00:00 9 rows
5QLQueryT.sql - DE..UHTATTEVose (7)) & X use Northwind; Siselect Companyliame, HonePage From Suppliers | where Homepage 1= nu1l | order by companyane; 00% - BB Resuts G Messages CompanyMame HomePage |1 [ Aoyeux ecciésasioues NULL |2 “Bifoot Breweres NULL |3 Cooperativade Quesos LasCabras’ NULL |4 Escargots Nouveaux NULL |5 Ectolauds NULL |6 Fortts derabies NULL |7 Gaipaturage NULL |8 Grandna Kell's Homestead NULL |9 Hel Sibwaren GrioH 8 Co. KG NULL |10 Koy NULL [ 11 Leka Tradng NULL |12 Ungbysid NULL |13 MaMason NULL |14 New Engand Seafood Cannery NULL |15 NordOst-Fisch Handelsgeselischaft mbH NULL 116 Norske Meierier NULL |17 Pasts Buttrisr. NuLL i 18 Paviova, lid NULL |19 PB Kniokebrid AB NuLL |20 Refrescos Amercanas LTDA NuLL |21 Specty Bacuts, i NuLL |22 Svensk sioda AB NuLL |23 Tokyo Traders NULL |24 Zsanse Snoepfabriek NULL SQLQuery1.sql - DE...UHT4T7E\ose (57))* + X KEEICNEHGITLE eV EygiaV e o)) =luse Northwind; “select Country, count(*) as 'number of customers’ from Customers GROUP by Country having count(*) >= 5 order by Country; 100% ~ FH Resutts [ Messages number of customers N DG w N - @ Query executed successfully. DES
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
SQLQuery1.sql - DE..UHTAT/EUose (57)* = X Sluse Northwind: Siselect OrderID,ProductID, (UnitPrice”Quantity) as ProductCost from OrderDetails where ProductId - 20 order by OrderID; 100% - 5 Ronts Gl Messages OueiD_Produetld PoducCon 1 [T 2 2920 2 e » 39880 3w 2 125600 4w » 60 5 2 181440 6 10514 2 315900 7o 2 121500 8 103 2 170100 s 10660 2 170100 0 08 2 40500 o 2 162000 2 o0 2 40500 B0 2 405000 U0 20 121500 BN 2 121500 ® 107 2 8100 © Query executed successfuly. DESKTOP-UI
SQLQueryT HTAT7EVose (5T)* & X Sluse Northwind; Hiselect distinct City from Employees order by City; 00% - BB Resuts i Messages @ Query executed successfully. SQLQuery1.sql - DE..UHT4T7EVose (57)° = X [ Sluse Northwind: Siselect Firstliame, Lastlame, City from Employees Where UPPER(City) TN (*LONDON',’SEATTLE', REDNOND'); 100% - B Rents Gl Mossages Fralame _ Ladfame ay 1 [Nancy ] Davolo Seatte 2 Magarel Pescock Redmond 3 Seven Buchanan London 4 Mcheel Syame London 5 Robet Kng London 6 L Calshan Sestie 7 Ame Dodswoth London © Query executed successfuly. DESKTOP-UHTATZE\SQLEXP
SQLQuery1.sql - DE..UHTAT7EVose (57 = % (RN VT TP Sluse Northwind: Sselect ProductID, Productliame, UnitPrice, UnitsInstock from Products Where UnitPrice bet: and UnitsInstock - @; en 20 and 25 00% - B9 Resuts g Messages ProductiD_ Prockctame. UntPrce UntsinSiock 1 [ | cref Anton's Gumbo M 2135 0 © Query executed successfuly
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help