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.

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
Get step-by-step solutions from verified subject matter experts
