Question: Plz provide the code and remove it 2 days after u have posted as I don't want to share it with others and copy what

Plz provide the code and remove it 2 days after u have posted as I don't want to share it with others and copy what I have written. Don't remove it before 2 days.

Plz provide the code and remove it 2 days after u have

al-1docx/?justUnlocked=1#question Faculty of Science O? 31 Course: Tutorial: Topic: CSCI 2000U Scientific Data Analysis #1 Part 1: SQL Your database: Table name (Attribute names) Customers (CustomerID, CustomerName, Contact Name, Address, City, Postal Code and Country) Write and test following SQL queries that: 1. Selects customers a all information b. only name, country and postal code. 2. Selects only distinct countries from the table customers 3. Selects all the customers that have IDs higher or equal than 50, than live either in Canada, Germany, Brazil, or Switzerland. 4. Selects all the customers from the country Germany and the city Berlin, or the country UK and the city London 5. Selects all the customers ordered by 2. city ascending b. city ascending and postal code ascending c. country ascending and city descending 6. Inserts new tuples into the customer table a. Including all columns information b. For only specific columns: customer ID, customer name, country and city. 7. Updates customer name and country for one of the customers inserted above 8. Deletes all added above customers inserted and updated above You should run all the queries at: httpwchools.com sl sql.asp?filename=Quiclect all Some tasks will require a browser that supports WebSQL (es, Chrome, Safan or Opera without it, the database is read-only Save all the queries as SQL_1.sql. Create a separate text file SQL_1_Results and keep the results of the queries there

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!