6. create a list of justlee\'s books and precede the cost of each book with aste

Question

6. create a list of justlee's books and precede the cost of each book with asterisks so that the width of the displayed cost field is 12. 7. determine the length of the data stored in the ISBN field of the BOOKS table. Make certain to have the length only display once (not once for each books). 8. Using today's date, determine the age (in months) of each book that JustLee sells. Make certain that only whole months are displayed, rather than portions of months. 9. Determine the calendar date of the next occurrence of Wednesday, based on today's date. 10. List the phonetic representation of all authors contained in JustLee's database.

Explanation / Answer

Please Rate 6) select Title ,lpad(cost,12,'*') from Books 7) select Title ,length(ISBN) from Books 8) 10) select A.AUTHORid , A.Lname , A.Fname ,BA.ISBN from BOOKAUTHOR BA,Author A where BA.AUTHORid =A.AUTHORid

Related Questions

Navigate

• Browse (All)
• Browse 6
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.