21 tm 25

Question 1

welke sellers kochten allemaal boxes of frogs? tabel items

Answer 1

select seller_id from items where name like ‘%boxes of frogs’

Question 2

toon de naam en de minimale prijs van boxes of frogs van de sellers 68,6,18

Answer 2

select name, min(cost) from items where name like ‘%boxes of frogs’ AND seller_id IN (68,6,18)

Question 3

subquery welke verkopers verkopen boxes of frogs voor welke prijs

Answer 3

select name, min(cost) from items where name like ‘%boxes of frogs’ and seller _id IN(
select seller_id from items where name like ‘%boxes of frogs’ )

Question 4

nieuwe custom tabel gecombineerd uit meerdere databases

Answer 4

select customer.id, customer.name, items.name, items.cost

from customers,items

where customer.id=seller_id ORDER BY customer.id

Question 5

query gecombineerd uit items en customers tabel

Answer 5

SELECT i.seller_id, i.name, c.id FROM customers AS c, items AS i WHERE i.seller_id=c.id

Question 6

toon alle customers die iets gekocht hebben

Answer 6

select customers.name, items.name FROM customers LEFT OUTER JOIN items ON customers.id=seller_id

Question 7

unions

name cost bids

2 query’s tegerlijk uitgevoerd

Answer 7

SELECT name, cost, bids FROM items WHERE bids>190

UNION (ALL)

SELECT name, cost, bids FROM items WHERE cost>1000

Question 8

zoek alle items met het woord baby in de tabel name

Answer 8

SELECT name, cost FROM items WHERE match(name) against (‘baby’) (+/- voor baby voor (not)include)