/*SELECT address
FROM studio
WHERE name='Disney';*/

/*SELECT birthdate
FROM MOVIESTAR
WHERE name = 'Jack Nicholson';*/

/*SELECT STARNAME
FROM STARSIN
WHERE MOVIEYEAR=1980 OR MOVIETITLE LIKE '%Knight%';*/

/*SELECT name
FROM MOVIEEXEC
WHERE NETWORTH>10000000;*/

/*SELECT name
FROM MOVIESTAR
WHERE GENDER='M' OR ADDRESS LIKE '%Perfect Rd%';*/

------------pc------------

/*SELECT model, speed AS 'MHz', hd AS 'GB'
FROM PC
WHERE price<1200;*/

/*SELECT DISTINCT maker
FROM product
WHERE type='Printer';*/

/*SELECT model,hd,screen
FROM laptop
WHERE price>1000;*/

/*SELECT *
FROM printer
WHERE color='y';*/

/*SELECT model, speed, hd
FROM pc
WHERE cd IN ('12x','16x') AND price < 2000;*/

/*SELECT class, country
FROM CLASSES
WHERE NUMGUNS<10;*/

/*SELECT name AS 'shipName'
FROM ships
WHERE LAUNCHED < 1918;*/

/*SELECT ship, battle
FROM OUTCOMES
WHERE result='sunk';*/

/*SELECT name
FROM ships
WHERE name=CLASS;*/

/*SELECT name
FROM ships
WHERE name LIKE 'R%';*/

SELECT name
FROM ships
WHERE name LIKE '% %';