Blog

An article published by a reputable news source is always considered credible according to the CRAAP Test, even if it lacks evidence and citations.

8. Assume there is a rating_history table with a column called rating_type that indicates if a movie’s rating is from a regular review, a critic’s review, or an audience award. What question does this correlated query answer? Begin your answer with “This query answers the question: which movies…” SELECT mov_titleFROM movie mWHERE NOT EXISTS (SELECT rh.mov_title                  FROM rating_history rh                  WHERE rh.mov_id = m.id                  AND rh.rating_type = ‘audience award’);

1. Find the names of all reviewers who have provided ratings for movies, listed without any duplicates.

4. Find the movies that are the only movie released by a director (In other words, show the movies where the director has directed only one movie). Hint: Subquery is needed

11. Create a new view that displays the movie title, genre, director’s name, and the average rating for each movie. Use the genreratingview from the previous question as the source in the FROM clause. Name the average rating column as AvgRating.

Suppose D is a 4×6 matrix and S is a pxq matrix. Suppose we compute the product DS. What is the number of rows and columns of DS, assuming the product is defined?

What is the largest possible rank of a 7×3 matrix?

State the following determinants for each matrix (just enter the number, with no decimals, in the box). Below are matrices are 3×3. [identity] The elementary matrix corresponding the row swap  

Determine which values of h make the following matrix invertible:

What is the largest possible rank of a 5×3 matrix?