Consider a table with the columns as shown below:
Movie(Title,ReleaseDate,Director,StudioName)
Express the following queries using SQL:
(a) Find all movies released on 1/11/2002.
(b) Find all movie titles produced by Sony Pictures.
(c) Count the number of movies that were released on 1/11/2002.
SELECT * FROM Movies
WHERE ReleaseDate = "1/11/2002"
SELECT Title FROM Movies
WHERE StudioName = "SonyPictures"
SELECT COUNT(*) FROM Movies
WHERE ReleaseDate = "1/11/2002"
You might also like to view...
The Settings charm allows users to ________
A) access the start screen B) access USB flash drives and printers C) shut down the machine D) send information to Facebook and Twitter
Aaron has created a report that tracks the animals going in and out of the animal shelter where he works. Each animal's record has been set up to print on a separate page. He wants to print the records for just the first 10 animals in the report. How would he do this?
What will be an ideal response?
Which of the following is a component of a form?
A. check box B. cell C. figure D. list item
________ is a language that enables Web page developers to create their own set of rules to define how data is to be represented on the Web.
a. HXML b. XML c. HTML d. XHTML