--96?
--97?
--98?

--99
UPDATE	MOVIE
SET		Movie_Year = '2013'
WHERE	Movie_Num = '1245';

--100
UPDATE	MOVIE
SET		Price_Code = '3'
WHERE	Movie_Genre = 'Action';

--101
UPDATE	PRICE
SET		Price_RentFee = Price_RentFee + 0.50;

--102?

--103
SELECT	Movie_Title, Movie_Year, Movie_Genre
FROM	MOVIE

--104
SELECT		Movie_Year, Movie_Title, Movie_Cost
FROM		MOVIE
ORDER BY	Movie_Year desc;

--105
SELECT		Movie_Title, Movie_Year, Movie_Genre
FROM		MOVIE
ORDER BY	Movie_Genre asc, Movie_Year desc;

--106
SELECT	Movie_Num, Movie_Title, Price_Code
FROM	MOVIE
WHERE	Movie_Title LIKE 'R%';

--107
SELECT		Movie_Title, Movie_Year, Movie_Cost
FROM		MOVIE
WHERE		Movie_Title LIKE '%Hope%'
ORDER BY	Movie_Title asc;

--108
SELECT	Movie_Title, Movie_Year, Movie_Genre
FROM	MOVIE
WHERE	Movie_Genre LIKE 'Action';

--109
SELECT	Movie_Num, Movie_Title, Movie_Cost
FROM	MOVIE
WHERE	Movie_Cost > 40;

--110
SELECT	Movie_Num, Movie_Title, Movie_Cost, Movie_Genre
FROM	MOVIE
WHERE	Movie_Genre IN ('Action', 'Comedy') AND Movie_Cost < 50
ORDER BY	Movie_Genre asc;

--111
SELECT	Mem_Num, Mem_FName, Mem_LName, Mem_Street, Mem_State, Mem_Balance
FROM	MEMBERSHIP
WHERE	Mem_State LIKE 'TN' AND Mem_Balance < 5 AND Mem_Street LIKE '%Avenue';

--112
SELECT		Movie_Genre, COUNT(*) AS [Number of Movies]
FROM		MOVIE
GROUP BY	Movie_Genre;

--113
SELECT	AVG(Movie_Cost) AS [Average Movie Cost]
FROM	MOVIE;

--114
SELECT		Movie_Genre, AVG(Movie_Cost) AS [Average Cost]
FROM		MOVIE
GROUP BY	Movie_Genre;

--115