basis 5 tm 10

Question 1

toon de tabel city uit de database customers

Answer 1

SELECT city FROM customers

Question 2

toon de id en city uit de database customers

2 querys tegerlijk tonen

Answer 2

SELECT city FROM customers;

SELECT id FROM customers;

Question 3

toon namen en postcode uit database customers

Answer 3

SELECT name,zip FROM customers

Question 4

toon alle tabellen uit database customers

Answer 4

SELECT * FROM customers

Question 5

toon alle unieke staten van database customers

Answer 5

SELECT DISTINCT state FROM customers

Question 6

toon eerste 5 id en name van database customers

Answer 6

SELECT id,name FROM customers LIMIT 5

Question 7

toon 6-15 id en name uit database customers

Answer 7

SELECT id,name FROM customers LIMIT 5, 10

Question 8

toon op alfabetische volgorde de namen van database customers

Answer 8

SELECT name FROM customers ORDER BY name

Question 9

toon namen en postcode georderdend op postcode van z-a uit database customers

Answer 9

SELECT name,zip FROM customers ORDER BY zip DESC

Question 10

toon de naam en id uit database customers gesorteerd op basis van id aflopend en toon alleen de hoogste

Answer 10

SELECT name, id FROM customers ORDER BY id DESC LIMIT 1

Question 11

toon id en name met id nummer 54 uit database customers

Answer 11

SELECT id, name FROM customers WHERE id=54

Question 12

toon id en name met id zonder 54 uit database customers

Answer 12

SELECT id, name FROM customers WHERE id !=54

Question 13

toon id en name waar id kleiner is dan 8 van database customers

Answer 13

SELECT id, name FROM customers WHERE id < 8

Question 14

toon id en name waar id kleiner is dan 8 inclusief 8 van database customers

Answer 14

SELECT id, name FROM customers WHERE id <=8

Question 15

toon id en name waar id zit tussen 25 en 30 uit database customers

Answer 15

SELECT id,name FROM customers BETWEEN 25 AND 30

Question 16

toon name en staat van CA

uit database customers

Answer 16

SELECT name, state FROM customers WHERE state = ‘CA’