Part IlI: Languages: SQL: (16 points) Id name artist id year 1 A Harc 2 Elvis Pr

Question

Part IlI: Languages: SQL: (16 points) Id name artist id year 1 A Harc 2 Elvis Presley 3 1989 1964 1956 2014 1968 4 Yellow Submarine 5 Hey Jude 6 Like a Virgin 1984 1969 1987 1970 7From Elvis in Memphis 8 Bad 9 Elton John 10 Like a Prayer 11 The Dark Side of the Moon 1973 1982 2012 7 12 Thriller Trowa 302 1979 14 The Wall 7 ld name 1 | The Beatles 2 I Elvis Presley 3 I Michael Jackson 4 | Madonna 5 | Elton John 6 | Led Zeppelin 71 Pink Floy Using the tables above, what would be the result of this query? Select from artists where id 3; Select from albums where artist id-3; We have a database called movies a) Give a statement to select all movies whose name begins with the letter 'A b) Give a statement that selects all movies made between 2000 and 2017

Explanation / Answer

I am not sure about the question since there are some mistakes in the table anyway i will suggest you two answers

select * from artist where id=3

then output will be

id name artist_id year

3 1989 2014

select * from artist where artist_id=3

id name artist_id year

8 bad 3 1987

12 Thriller 3 1982

select * from album where id =3

id name

3 Michael jackson

a)

b)

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---