Blog

A mother with type B blood has two children, one with type A blood and one with type O blood.  Her husband has type O blood.  Which of the following could you conclude from this information?

If two males of the same species compete directly with one another over access to a group of females, this is a form of:

A source’s relevance to your research topic is just as important as its authority when applying the CRAAP Test criteria.

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?