Description
* please Do from Q11 to Q 22 short answer
see the Question in file word
.........................................................................
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Hey am through. Check out the correct answers in the attached word file
Q 11:
SELECT * FROM BOOKS
JOIN AUTHORS_BOOKS ON BOOKS.ID = AUTHORS_BOOKS.BOOK_ID
JOIN AUTHORS ON AUTHORS.ID = AUTHORS_BOOKS.AUTHOR_ID
WHERE AUTHORS.NAME LIKE “%JIM%”
Q :12
The statement returns authors’ name and the count of books by each author.
The query will return five columns and two rows.
Q 14:
The SQL Gives the Last Name, First Name the job names of the individuals
Query:
select p.lastname, p.firstname, j.name
from
jobs as j, jobassignment as ja, person as p
where
j.jobid = ja.jobid and
ja.personid = p.personid
AND p.firstname like 'J%'
Query
-----------------select p.lastname, p.firstname
from
person as p
where
p.Shift like 'red%'
Q 16:
1.
2.
3.
4.
Query number 1 returns all the names of publishers who have id of less than four
Query number 2 throws a type conversion error
Query number 3 returns publishers whose id equals to four.
Query number 4 throws a type conversion error
Q 17:
SELECT * FROM BOOKS
JOIN AUTHORS_BOOKS ON BOOKS.ID = AUTHOR...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!