Question

FIGURE P8.47 THE CH08_MOVIECO ERD DETAILRENTAL MEMBERSHIP PK,FK1 RENT NUM PK,FK2 VID NUM RENTAL PK MEM NUM RENT NUM PK H-O |МЕМ_FNAME MEM_LNAME MEM STREET МЕМ СITY MEM STATE MEM ZIP МЕМ ВBALANCЕ DETAIL_FEE DETAIL_DUEDATE DETAIL_RETURNDATE DETAIL DAILYLATEFEE RENT DATE FK1 MEM NUM MOVIE VIDEO VID NUM MOVIE NUM PK PK H-O PRICE MOVIE_TITLE MOVIE_YEAR MOVIE COST MOVIE GENRE FK1 PRICE_CODE VID INDATE FK1 MOVIE NUM PK PRICE CODE +0 -OE PRICE DESCRIPTION PRICE RENTFEE PRICE DAILYLATEFEE

NEED the SQL query that solves each problem

4) List the member numbers of all members who rented a movie. Do not list duplicates. (w3schools -> SQL Distinct)

5) List the member names [first and last] for members from Kentucky {KY}. (w3schools -> SQL Where)

6) List the names of all movies in alphabetical order (w3schools -> SQL ORDER BY)

7) List the movie title and cost in descending order by cost (w3schools -> SQL Order By)

8) List all information for movies that cost $50 or less (w3schools -> SQL Where)

Answer 1

If you have any doubts, please give me comment...

-- 4

SELECT DISTINCT MEM_NUM

FROM RENTAL;

-- 5

SELECT MEM_FNAME, MEM_LNAME

FROM MEMBERSHIP

WHERE MEM_STATE = 'KY';

-- 6

SELECT MOVIE_TITLE

FROM MOVIE

ORDER BY MOVIE_TITLE;

-- 7

SELECT MOVIE_TITLE, MOVIE_COST

FROM MOVIE

ORDER BY MOVIE_COST DESC;

-- 8

SELECT *

FROM MOVIE

WHERE MOVIE_COST<=50;