Question

Normalizatoin and SQL Join

Display all states the LifeStyle has a business (customer or supplier). Show state and country.

Display all states the LifeStyle ha State Country Beijing China 1 CA USA 2 England 3 UK 4 GA USA IL USA 6 NY USA 7 Ontario Canada 8 South Korea Suwon 9 Tokyo Japan 10 USA WA L APPENDIX B: LIFESTYLE DATABASE TABLES Sales.Customers Table Contact Email Country Customerid PostalCode StreetAddress State CustomerName Cty [email protected] John White USA 12012 Just Bectronics 123 Broad way NY New York Scott Green [email protected] USA 32302 Beyond Electronics 2 45 Chery Street Chicago Atlanta IL black [email protected] Alce Black USA 43347 3 GA Beyond Blectronics 6767 GameOver Blvd [email protected] [email protected] [email protected] [email protected] USA Ben Gold 69356 E Fun 888 Main Ave. WA 4 Seattle Daniel Yellow USA 32302 5 Overstock E 39 Garden Place Los Angeles CA Frank Green UK E Fun 915 Market st. EC1A 1BB 6 England London Grace Smith UK 83 2EW 7 Bectronics4U 27 Colmore Row England Bimingham NULL NULL Canada Cheap Blectronics K1A 0B1 1010 Easy St Ontario Otawa HR.Employees Table HomeAddress Phone Managerld State PostalCode LastName City BithDate HreDate Employeeld Frst Name (434) 290-3322 NULL New Canton VA 23123 1990-02-03 2015-08-09 85 Main Ln Alex Hall New Canton (434) 290-1122 1 2010-08-01 VA 23123 1978-12-03 209 Social Hall Blvd 2 Dianne Hart 23123 VA (434) 531-5673 2012-08-21 258 Blinkys St New Canton 1988-07-13 3 Mara Law (434) 531-1010 (434) 531-1034 1988-12-13 VA 23123 2012-04-22 300 Vista Valley Blvd Buckingham Law 4 Aice 1982-11-09 Buckingham VA 23123 2 2015-04-12 1 Old Fteen St 5 Black Hart 2014-06-15 217 Chapel St New Canton VA 23123 2 1978-07-13 NULL 6 Christina Robinson 26 N James Madia. 2013-05-22 Buckingham VA 23123 3 1977-10-05 NULL 7 Nicholas Pinkston Purchasing.Suppliers Table City SupplierName Pine Apple StreetAddress State PostalCode Country Supplierld Idanha 1 Pine Apple St. CA 1 87201 USA 123 Intemational Blvd Los Angeles CA 2 IMB 89202 USA 33 Beijin Square Beijing Yeongtong Beijing 3 Lonovo 100201 China 1 Bectronics Road Samsong Suwon 30174 South Korea 12 Camera St Ota 5 Canan Tokyo 100-0121 Japan 306

Answer 1

Please find the SQL query below.

SELECT State, Country FROM Customers

JOIN

SELECT State, Country FROM Suppliers;