DATABASE- PERTEMUAN 8

Drag and Drop

​

Placeholder

​ customerNumber​ ,customerName ​

Placeholder

customers

Drag these tiles and drop them in the correct blank above

From

select

where, filter

group, aggregate

join, merge

insert

Drag and Drop

​

Placeholder

customers (customerNumber,customerName) ​

Placeholder

(1001,'Randi');

Drag these tiles and drop them in the correct blank above

insert into

values

SELECT * FROM

UPDATE

DELETE FROM

SET

GROUP BY

Drag and Drop

​

Placeholder

​

Placeholder

customerName='DADAN SAPUTRA' ​

Placeholder

customerNumber='1011';

Drag these tiles and drop them in the correct blank above

UPDATE customers

WHERE

SET

DELETE FROM

INTO

INSERT

ORDER

BY

Match

select orderDate from orders where month(orderDate)=05;

• select

• orderDate

• from

• orders

• where month(orderDate)=05;

code

code

code

code

code

• code

• code

• code

• code

• code

Match

select count(buyPrice),productLine from products where productLine='Planes';

• select

• count(buyPrice),productLine

• from

• products

• where productLine='Planes';

code

code

code

code

code

• code

• code

• code

• code

• code

Match

select productName,quantityInStock from products where quantityInStock<=400 ;

• select

• productName,quantityInStock

• from products

• where

• quantityInStock<=400 ;

code

code

code

code

code

• code

• code

• code

• code

• code

Match

INSERT INTO PRODUCTS (productName,quantityInStock) VALUES ('HONDA HRV','10');

• INSERT

• INTO PRODUCTS

• (productName,quantityInStock)

• VALUES

• ('HONDA HRV','10');

code

code

code

code

code

• code

• code

• code

• code

• code

Drag and Drop

​

Placeholder

​ customerNumber, customerName ​

Placeholder

customers​

Placeholder

​

Placeholder

customerName ​

Placeholder

Drag these tiles and drop them in the correct blank above

From

select

order

by

ASC

where

INSERT

UPDATE

GROUP BY

Drag and Drop

​

Placeholder

customerName,contactLastName ​

Placeholder

customers ​

Placeholder

​

Placeholder

​

Placeholder

'Thompson';

Drag these tiles and drop them in the correct blank above

SELECT

FROM

WHERE

contactLastName

=

INSERT

UPDATE

DELETE

Drag and Drop

​

Placeholder

customerName,contactLastName ​

Placeholder

customers ​

Placeholder

customerName ​

Placeholder

​ '%Ltd';

Drag these tiles and drop them in the correct blank above

SELECT

FROM

WHERE

LIKE

INSERT

UPDATE

DELETE

+

Drag and Drop

​

Placeholder

​

Placeholder

AS terendah ​

Placeholder

payments;

Drag these tiles and drop them in the correct blank above

SELECT

MIN(amount)

FROM

INSERT, MAX(amount)

UPDATE, AVG(amount)

DELETE, SUM(amount)

MIN AMOUNT

Drag and Drop

​

Placeholder

orderdetails ​

Placeholder

​

Placeholder

orderNumber ​

Placeholder

​

Placeholder

Drag these tiles and drop them in the correct blank above

SELECT * FROM

ORDER

BY

ASC

LIMIT 5 ;

DELETE FROM orderdetails

UPDATE orderdetails SET

SELECT FROM

BUY

DELETE FROM

Drag and Drop

SELECT ​

Placeholder

as name , jobTitle ​

Placeholder

employees ​

Placeholder

jobTitle= 'President' ​

Placeholder

​

Placeholder

Drag these tiles and drop them in the correct blank above

CONCAT(firstName,' ', lastName)

FROM

WHERE

OR

jobTitle= 'VP Marketing';

SELECT *

JOIN

GROUP BY

Drag and Drop

​

Placeholder

orderDate from orders ​

Placeholder

​

Placeholder

​

Placeholder

2003 ​

Placeholder

2005;

Drag these tiles and drop them in the correct blank above

select

where

year(orderDate)

and

between

INSERT

ORDER BY

ASC

GROUP BY

Match

DELETE FROM CUSTOMERS WHERE customerNumber='12345';

• DELETE

• FROM CUSTOMERS

• WHERE

• customerNumber=

• '12345';

code

code

code

code

code

• code

• code

• code

• code

• code