xiaoshudewo的博客

SELECT from Nobel 1.Change the query shown so that it displays Nobel prizes for 1950. SELECT yr, subject, winner FROM nobel WHERE yr = 1950 2.Show who won the 1962 prize for Literature. SELECT...

The JOIN operation 1.List the films where the yr is 1962 [Show id, title] 2.Give year of ‘Citizen Kane’. 3.List all of the Star Trek movies, include the id, title and yr (all of these movies includ...

这里涉及两个表： teacher(id,dept,name,phone,mobile); dept(id,name); 1.List the teachers who have NULL for their department. SELECT name FROM teacher WHERE dept IS NULL 2.Note the INNER JOIN misses the...

1.How many stops are in the database. SELECT COUNT(*) FROM stops 2.Find the id value for the stop ‘Craiglockhart’ SELECT id FROM stops WHERE name = ‘Craiglockhart’ 3.Give the id and the name f...