MySQL 2 Part

select * from musa order by name asc;
select * from musa order by name desc;
select * from musa where name like "%a" "a%" "%a%";
select * from musa where id between 1 and 2;
select distinct name from musa;
SELECT home_type FROM Rooms GROUP BY home_type
SELECT home_type, AVG(price) as avg_price FROM Rooms
GROUP BY home_type HAVING avg_price 50
SELECT family_member, member_name FROM Payments
INNER JOIN FamilyMembers
ON Payments.family_member = FamilyMembers.member_id