Suppose that we have a relational database with the following table. Underlined one represent primary key Movies (mid, title, year) People (pid…
Suppose that we have a relational database with the following table. Underlined one represent primary key
Movies (mid, title, year)
People (pid, name)
Genres (gid, genre)
HasRole (pid, mid, role)
HasGenre (gid, mid)
Write a SQL query to return the number of movies that are romantic comedies.
From the BB Assistant Programmer February 2023 – Written (BIBM) exam, question 30 of 37.
More from this paper
- Previous: Given two integers A and B as input write a program to compute the least common multiple of A and B.
- Next: Consider the following code: public class ClassA { public void m1() {} public void m2(int i) {} public void m3(int i) {} public static…
- All questions in BB Assistant Programmer February 2023 – Written (BIBM)