TMA SQL QUIZ

SQL adalah......

• Structured Query Layer

• Sequence Query Language

• Structured Query Language

• Sistem Query Language

Lengkapi Statement SQL di bawah ini :

_____ * FROM world

SELECT name, population

FROM world

WHERE name IN ('France','Germany','Italy')

• 
• 
• 
• 

Jawab dengan huruf KAPITAL, gunakan spasi antar jawaban :

SELECT * ____ world

_____ name = 'France'

Pilih Statement yang benar :

• SELECT name, population WHERE FROM bbc region = 'Europe'

• SELECT SUM(population ) FROM bbc WHERE region = 'Europe'

• SELECT SUM(population FROM bbc WHERE region = 'Europe')

• SUM population FROM bbc WHERE region = 'Europe'

SELECT region, SUM(area)

FROM bbc

WHERE SUM(area) > 15000000

GROUP BY region

• TIDAK ERROR

• ERROR

SELECT population FROM bbc WHERE name LIKE ('Poland', 'Germany', 'Denmark')

• ERROR

• TIDAK ERROR

SELECT subject, COUNT(subject)

FROM nobel

WHERE yr ='1960'

GROUP BY subject

• ERROR

• TIDAK ERROR

Join dengan hasil irisan antara 2 tabel (HURUF CAPITAL):

SELECT Orders.OrderID, Customers.CustomerName

FROM Orders

_____ ____ Customers ON Orders.CustomerID = Customers.CustomerID

SELECT

Orders.OrderID AS ORDER_,

Customers.CustomerName AS CUSTOMER_

FROM Orders

INNER JOIN Customers ON Orders.CustomerID = Customers.CustomerID;

• 
• 
• 
•