A GUIDE TO SQL
A GUIDE TO SQL
9th Edition
ISBN: 9781305897397
Author: Pratt
Publisher: CENGAGE L
bartleby

Concept explainers

Question
Book Icon
Chapter 4, Problem 13SCG
Program Plan Intro

“SELECT” command:

The “SELECT” command is used to retrieve data in a database.

Syntax for selecting values from the table is as follows:

SELECT STUDENT_ID FROM STUDENT;

  • The given query is used to display each student ID from “STUDENT” table.

“COUNT” function:

  • It is the one function of aggregate function.
  • The “COUNT” function is used to compute the number of rows in a table.

Example:

The example for “COUNT” function is given below:

SELECT COUNT(*) FROM STUDENT WHERE MARK_CREDIT >= 90;

The above query is used to display the number of students whose mark credit is greater or equal to “90” by using “COUNT” function.

  • From the given query, the asterisk (*) represent any column.
  • User can also count the number of rows in a query by selecting a particular column instead of using the asterisk.
    • The below example is as follows

      SELECT COUNT(STUDENT_ID) FROM STUDENT WHERE MARK_CREDIT >= 90;

“ORDER BY” Clause:

  • User can sort the data in specific order using “ORDER BY” clause.
  • The column on which to sort data is called a sort key or a simple key.
  • To sort the output, use an “ORDER BY” clause followed by the sort key.
  • If the user does not indicate a sort order, the output displayed in default order that is ascending order.

Example:

The example for “ORDER BY” clause is given below:

SELECT STUDENT_ID, STUDENT_NAME, STUDENT_CREDIT FROM STUDENT ORDER BY STUDENT_CREDIT;

 The above query is used to list student ID, name and credit for each student with ascending order of student credit using an “ORDER BY” clause.

  • From the given query, the sort key is “STUDENT_CREDIT”. So, the rows are sorted in ascending order by “STUDENT_CREDIT”.

“GROUP BY” Clause:

  • User can group the data using “GROUP BY” clause.
  • The GROUP BY clause is used to group the result of a SELECT statement done on a table where the tuple values are similar for more than one column.

Example:

The example for “GROUP BY” clause is given below:

SELECT CUSTOMER_NAME, SUM(AMOUNT) FROM CUSTOMERS GROUP BY CUSTOMER_NAME;

The above query is used to list the customer name and the sum of amount using “GROUP BY” clause.

Blurred answer
Students have asked these similar questions
I need help finishing my python rock paper scissors code, where it asks the user "rock, paper, scissors", the user types either option (repeatedly asks until its one of the three), and for a random option from the code to select also rock paper scissors. The end result would be you winning, code winning, or a tie.My code:import randomOPTIONS = ("ROCK", "PAPER", "SCISSOR") def getInput():    """        Function getInput() will receive and validate user input to be        the string ROCK, PAPER, or SCISSOR.  Input must be spelled correctly        and in all capital letters.  Function will return the validated input         @return user input as ROCK, PAPER, OR SCISSOR    """    #need help here def checkWinner(user, computer):    """        Function checkWinner will accept 2 string parameters that must be unique        values of ROCK, PAPER, or SCISSOR.  Functions should return true if the        string in parameter user beats the string in parameter computer in a game        of rock…
I need help understanding how could I got the IP Address for the 1st Host on this Subnet, the IP Address for the Last Host on this Subnet & the Broadcast Address for this Subnet My Explanation:8 bits --> 17 & 0    128  64  32  16  |  8  4  2  1      0    0    0     1     0  0  0  1  -->17+    0    0    0     0     0  0  0  0  --> 0      0    0    0     0     0  0  0  0  --> 0 (The Major (Base) Network Address): 142.20.33.0 To find the broadcast address, we can set all the bits in the host portion of the address to 1, which gives us 142.20.33.255. Based on the subnet mask 255.255.255.0, no bits were borrowed from the host portion, meaning 8 bits remain in the host portion. Using the formula 2^h – 2 (where h represents the number of host bits), we get 2^8 - 2 = 254 hosts.  8 bits --> 17 & 252       128  64  32  16  |  8  4  2  1        0    0     0     1     0  0  0  1  --> 17+      1    1     1     1     1  1  0  0  --> 252       0    0      0     1…
Which of the following opens when you click the launcher in the Size group on the Ribbon? Question 19Select one: a. Size dialog box b. Layout dialog box c. Width and Height dialog box d. Format dialog box

Chapter 4 Solutions

A GUIDE TO SQL

Knowledge Booster
Background pattern image
Computer Science
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
  • Text book image
    A Guide to SQL
    Computer Science
    ISBN:9781111527273
    Author:Philip J. Pratt
    Publisher:Course Technology Ptr
    Text book image
    Oracle 12c: SQL
    Computer Science
    ISBN:9781305251038
    Author:Joan Casteel
    Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Text book image
Oracle 12c: SQL
Computer Science
ISBN:9781305251038
Author:Joan Casteel
Publisher:Cengage Learning