Basis Data Kuis DDL dan DML

A. SELECT

Insert the missing statement to get all the columns from the Customers table.

………. * FROM Customers;

A. SELECT

Write a statement that will select the City column from the Customers table.

…………   ……….   ………..  Customers;

A. SELECT

Select all the different values from the Country column in the Customers table.

………..   ………..   Country FROM Customers;

B. WHERE

Select all records where the City column has the value "Berlin".

SELECT * FROM Customers

…………   ………… = ‘………’;

B. WHERE

Use the NOT keyword to select all records where City is NOT "Berlin".

SELECT * FROM Customers

………… …… ……… = ‘…………’

B. WHERE

Select all records where the CustomerID column has the value 32.

SELECT * FROM Customers

………… CustomerID = ……;

B. WHERE

Select all records where the City column has the value 'Berlin' and the PostalCode column has the value 12209.

………… * FROM Customers

……… City = ‘Berlin’

…… ……… = 12209;

B. WHERE

Select all records where the City column has the value 'Berlin' or 'London'.

………… * FROM Customers

……… City = ‘Berlin’

…… ……… = ‘………’;

C. ORDER BY

Select all records from the Customers table, sort the result alphabetically by the column City.

SELECT * FROM Customers

……… … ………;

C. ORDER BY

Select all records from the Customers table, sort the result reversed alphabetically by the column City.

SELECT * FROM Customers

…… … …… ……;