MIS 235- SQL Project 2-1

MIS 235- SQL Project 2-1 - E 1 RY 278 Rovelli Gifts...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Nicholas Connolly MIS 235- N SQL Project 2-1 10/6/2010 1) Select* From zhaoc.customers Where country= 'USA' CUSTOMERNUMBER CUSTOMERNAM E PHONE ADDRESSLINE 1 CITY COUNT RY SALESR 131 Land of Toys Inc. 21255578 18 897 Long Airport Avenue NYC USA 181 Vitachrome Inc. 21255515 00 2678 Kingston Rd. NYC USA 363 Online Diecast Creations Co. 60355586 47 2304 Long Airport Avenue Nashua USA 486 Motor Mint Distributors Inc. 21555598 57 11328 Douglas Av. Philadelph ia USA 487 Signal Collectibles Ltd. 41555543 12 2793 Furth Circle Brisbane USA 495 Diecast Collectables 61755525 55 6251 Ingle Ln. Boston USA 6 Rows Selcted * 2) SELECT customerNumber, city, country FROM zhaoc.Customers WHERE CustomerName = 'Land of Toys Inc.' OR CustomerName = 'Rovelli Gifts' CUSTOMERNUMBER 131 NY 278 Be 3) Select* From zhaoc.customers Where country='Italy' CUSTOMERNUMBER CUSTOMERNAM PHONE ADDRESSLINE CITY COUNT SALESREP
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: E 1 RY 278 Rovelli Gifts 035-640555 Via Ludovico il Moro 22 Berga mo Italy 473 Frau da Collezione +39 0225155 55 20093 Cologno Monzese Milan Italy 4) Select* From zhaoc.Customers Where CustomerNumber >100 and CustomerNumber < 500 CUSTOMERNUMBER CUSTOMERNAME PHONE ADDRESS 121 Baane Mini Imports 07-98 9555 Erling Skakkes g 128 Blauer See Auto Co. +49 69 66 90 2555 Lyonerstr. 34 131 Land of Toys Inc. 2125557818 897 Long Airport 141 Euro+ Shopping Channel (91) 555 94 44 C Moralzarzal 86 495 Diecast Collectables 6175552555 6251 Ingle Ln. Boston USA 15 Rows Selected* 5) Select Sum(priceEach*quantityOrdered) FROM zhaoc.customers, zhaoc.Orders, Zhaoc.OrderDetails WHERE customerName = 'Vitachrome Inc.' SUM(PRICEEACH*QUANTITYORDERED) 1141805.2...
View Full Document

This note was uploaded on 11/15/2011 for the course MIS 235 taught by Professor Sunrro during the Fall '08 term at Miami University.

Page1 / 2

MIS 235- SQL Project 2-1 - E 1 RY 278 Rovelli Gifts...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online