Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Databases And Information Systems 1 International Baltic Conference Dbandis 2020 Tallinn Estonia June 19 2020 Proceedings

Authors: Tarmo Robal ,Hele-Mai Haav ,Jaan Penjam ,Raimundas Matulevicius

1st Edition

303057671X, 978-3030576714

More Books

Students also viewed these Databases questions

Question

8. Document data as evidence in complete and detailed notes.

Answered: 1 week ago