Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Administrator Limited Edition

Authors: Martif Way

1st Edition

B0CGG89N8Z

More Books

Students also viewed these Databases questions

Question

Evaluate employees readiness for training. page 275

Answered: 1 week ago