DATABASE- PERTEMUAN 8

Presentation

•

Computers

•

11th Grade

•

Practice Problem

•

Easy

echa Putra

Used 6+ times

FREE Resource

0 Slides • 15 Questions

Drag and Drop

customerNumber ,customerName

customers

Drag these tiles and drop them in the correct blank above

From

select

where, filter

group, aggregate

join, merge

insert

Drag and Drop

customers (customerNumber,customerName)

(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

customerName='DADAN SAPUTRA'

customerNumber='1011';

Drag these tiles and drop them in the correct blank above

UPDATE customers

WHERE

SET

DELETE FROM

INTO

INSERT

ORDER

Match

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

select

orderDate

from

orders

where month(orderDate)=05;

code

Match

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

select

count(buyPrice),productLine

from

products

where productLine='Planes';

code

Match

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

select

productName,quantityInStock

from products

where

quantityInStock<=400 ;

code

Match

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

INSERT

INTO PRODUCTS

(productName,quantityInStock)

VALUES

('HONDA HRV','10');

code

Drag and Drop

customerNumber, customerName

customers

customerName

Drag these tiles and drop them in the correct blank above

From

select

order

ASC

where

INSERT

UPDATE

GROUP BY

Drag and Drop

customerName,contactLastName

customers

'Thompson';

Drag these tiles and drop them in the correct blank above

SELECT

FROM

WHERE

contactLastName

INSERT

UPDATE

DELETE

Drag and Drop

customerName,contactLastName

customers

customerName

'%Ltd';

Drag these tiles and drop them in the correct blank above

SELECT

FROM

WHERE

INSERT

UPDATE

DELETE

Drag and Drop

AS terendah

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

orderdetails

orderNumber

Drag these tiles and drop them in the correct blank above

SELECT * FROM

ORDER

ASC

LIMIT 5 ;

DELETE FROM orderdetails

UPDATE orderdetails SET

SELECT FROM

BUY

DELETE FROM

Drag and Drop

SELECT

as name , jobTitle

employees

jobTitle= 'President'

Drag these tiles and drop them in the correct blank above

CONCAT(firstName,' ', lastName)

FROM

WHERE

jobTitle= 'VP Marketing';

SELECT *

JOIN

GROUP BY

Drag and Drop

orderDate from orders

2003

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

customerNumber ,customerName

customers

Drag these tiles and drop them in the correct blank above

From

select

where, filter

group, aggregate

join, merge

insert

Show answer

Auto Play

Slide 1 / 15

DRAG AND DROP

Similar Resources on Wayground

11 questions

Density

Presentation

•

10th Grade

9 questions

-ed -ing adjectives

Presentation

•

11th Grade

11 questions

Lead Workplace Communication

Presentation

•

11th Grade

13 questions

การจัดการไฟล์และ folder

Presentation

•

10 questions

Parallel Structure

Presentation

•

10th - 12th Grade

10 questions

Cell organelles

Presentation

•

10th Grade

11 questions

Electromagnet and Magnetism Recap

Presentation

•

8th Grade

11 questions

Context Clues

Presentation

•

10th Grade

Popular Resources on Wayground

24 questions

PBIS-HGMS Day 10

Quiz

•

6th - 8th Grade

10 questions

HCS SCI 03 Summer School Review 3

Quiz

•

3rd Grade

11 questions

Home Scope

Quiz

•

7th - 8th Grade

15 questions

HCS SCI 05 Summer School Assessment 3 Review

Quiz

•

5th Grade

35 questions

Lufkin Road Middle School Student Handbook & Policies Assessment

Quiz

•

7th Grade

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade

Discover more resources for Computers

18 questions

Geo 11.3 Area of Circles and Sectors

Quiz

•

9th - 11th Grade