Question: * Problems 1 - 1 2 start with SELECT P 1 . Write an SQL statement that will select the City column from the Customers

*Problems 1-12 start with SELECT
P1. Write an SQL statement that will select the City column from the Customers table (10 points).
SELECT
FROM
P2. Write an SQL statement that will select all the different values from the Country column in the Customers table (10 points).
P3. Write an SQL statement that will select all records where the City column has the value "Berlin" (10 points).
P4. Write an SQL statement that will use the NOT keyword to select all records where City is NOT "Berlin" (10 points).
P5. Write an SQL statement that will select all records where the CustomerID column has the value 20(10 points).
P6. Write an SQL statement that will select all records where the City column has the value 'Berlin' and the PostalCode column has the value 12209(10 points).
* Problems 1 - 1 2 start with SELECT P 1 . Write

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 Programming Questions!