text: CREATE TABLE publication (Price VARCHAR, Publisher VARCHAR) -- Show the prices of publications whose publisher is either "Person" or "Wiley" SELECT Price FROM publication WHERE Publisher = "Person" OR Publisher = "Wiley" CREATE TABLE actor (Id VARCHAR) -- How many actors are there? SELECT COUNT(*) FROM actor CREATE TABLE actor (Name VARCHAR) -- List the name of actors in ascending alphabetical order. SELECT Name FROM actor ORDER BY Name CREATE TABLE actor (Character VARCHAR, Duration VARCHAR) -- What are the characters and duration of actors? SELECT Character, Duration FROM actor CREATE TABLE actor (Name VARCHAR, Age VARCHAR) -- List the name of actors whose age is not 20. SELECT Name FROM actor WHERE Age <> 20 CREATE TABLE actor (Character VARCHAR, age VARCHAR) -- What are the characters of actors in descending order of age? SELECT Character FROM actor ORDER BY age DESC CREATE TABLE actor (Duration VARCHAR, Age VARCHAR) -- What is the duration of the oldest actor? SELECT Duration FROM actor ORDER BY Age DESC LIMIT 1 CREATE TABLE musical (Name VARCHAR, Nominee VARCHAR) -- What are the names of musicals with nominee "Bob Fosse"? SELECT Name FROM musical WHERE Nominee = "Bob Fosse" CREATE TABLE musical (Nominee VARCHAR, Award VARCHAR) -- What are the distinct nominees of the musicals with the award that is not "Tony Award"? SELECT DISTINCT Nominee FROM musical WHERE Award <> "Tony Award" CREATE TABLE actor (Name VARCHAR, Musical_ID VARCHAR); CREATE TABLE musical (Name VARCHAR, Musical_ID VARCHAR) -- Show names of actors and names of musicals they are in. SELECT T1.Name, T2.Name FROM actor AS T1 JOIN musical AS T2 ON T1.Musical_ID = T2.Musical_ID