Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Question 18 Using Books tables, evaluate the following SELECT statement: Not yet Books Tables answered Marked out of 5.00 ISBN BOOK TITLE LANGUAGE NUMBER OF
Question 18 Using Books tables, evaluate the following SELECT statement: Not yet Books Tables answered Marked out of 5.00 ISBN BOOK TITLE LANGUAGE NUMBER OF PAGES PUBLISHER_NAME AUTHER NAME PUBLISH_DATE PRICE 28564 Fransh The Stranger 123 Vintage International Albert Camus 28-Mar-1989 P Flag question 7.3 20154 Big Data English 352 Prentic Hall Batric Henrik 11-Sep-2002 97861 100 ways for him Arabic 178 Dar Al-Fiker Ali Al-Hamadi 10-May-2011 10 97877 100 ways for her Arabic 170 Dar Al-Fiker Ali AL-Hamadi 05-Jul-2012 10 97899 9 secrets of memorizing Quran Arabic 182 Alwataniya Maji Obaid 01-Jan-1970 5 97803 Introduction To Database Systems English 254 Microsoft Corporation Desai, Bipin C 12-Apr-2000 8.5 1318 Mastering MATLAB 7 English 544 Prentic Hall Hanselman, Duane C 19-Dec-2005 19.4 what will be the output of the SELECT statements? 1- SELECT instr (book_title, 'D') FROM books WHERE price is null; Answer: 2- SELECT length (book_title) FROM books WHERE price 10; Answer: 5- SELECT NVL2 (number_of_pages, price, 0) FROM books WHERE ISBN = 1318
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started