Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 1: Write down SQL statements to create tables, attributes and relationships given below: StateProvince SED Stade Country Country Cou 1. Ladies Add Oy Staten
Question 1: Write down SQL statements to create tables, attributes and relationships given below: StateProvince SED Stade Country Country Cou 1. Ladies Add Oy Staten Question 2: Write SQL statements to apply following option on Table SalesOrder Detail given below: 1. Remove all the rows where Carrier Tracking Number is 4911-403C-98 2. Delete column UnitPriceDiscount 3. Change data type of column OrderQty to text 4. Select all the rows where Carrier TrackingNumber is 6431- 4D57-83 or 4E0A-4F89-AE 5. Select Carrier Tracking Number where "C" is at ninth position Question 3: Rewrite and correct the following SQL statements given below: 1. The syntax for left join is: SELECT Customer Account Number, Customer CustomerID, Store, StorelD FROM Customer LEFT JOIN Store WHERE Customer CustomerID = Store.CustomerID ORDER BY Customer Account Number: 2. Select statement: SELECT city, Sate Province; FROM Address WHERE DISTICNT city, 3. Select statement: SELECT Address.City: Address.PostalCode WHERE Address.City="Portland' FROM Address
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started