Please answer this please

consider the following relational model CREATE TABLE Movies ( MID int Primary key, Title varchar(20), Released int ); CREATE TABLE Person( PID

Answer all the following SQL queries (you could not use a database to do that)

1) select DISTINCT pp.mid, pp.pid from movies m, person p, Participate pp, Roles r where pp.pid = p.pid and r.rid

2) select DISTINCT pp.mid, count(*) from movies m, Participate pp where m.mid = pp.mid group by pp.mid