903 the number of fields 5 the order of results

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: ree fields in the result set 6.903% The number of fields: 5, The order of results: Ascending Kai Zhao 4/15/12 9:12 PM Comment [3]: would need to be price < 10 or price > 15 to be valid 1.972% The number of fields: 3, The order of results: Descending Kai Zhao 4/15/12 9:11 PM Comment [2]: James presumably is meant to be a value in the author field. If so, it needs to be in quotes to be a proper string. 81.065% The number of fields: 5, The order of results: Descending Kai Zhao 4/15/12 9:09 PM Comment [1]: Fields are separated by comma, not 'and' 0.592% Question 3: Multiple Choice Average Score 1.25444 points Which of the following queries returns the title of ALL books that contain "SQL" from "books" table? Correct Percent Answered Select title from books where title like "%SQL%" 62.722% Select tit...
View Full Document

This document was uploaded on 02/17/2014 for the course CS 105 at University of Illinois, Urbana Champaign.

Ask a homework question - tutors are online