A Guide to SQL
9th Edition
ISBN: 9781111527273
Author: Philip J. Pratt
Publisher: Course Technology Ptr
expand_more
expand_more
format_list_bulleted
Question
Chapter 8, Problem 1CAT
Program Plan Intro
SELECT statement:
It is used to retrieve information from the table or database. The syntax for the “SELECT” statement is given below:
Syntax:
SELECT * FROM table_Name;
“UPPER” keyword:
The keyword “UPPER” is used to convert the string into capital letters that is, it converts the string into upper case letters.
Syntax:
SELECT UPPER (column_Name) FROM table_Name;
“LOWER” keyword:
The keyword “LOWER” is used to convert the string into small letters that is, it converts the string into lower case letters.
Syntax:
SELECT LOWER (column_Name) FROM table_Name;
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Is it possible to speed up the process of reprogramming views?
Write C# code to update data in the database table. The fields are Student_Id, Student_Name, Major, and PhoneNumber.
The data in flat files has been provided:
INVOICE TABLE
INVOICE_NUM
CUSTOMER_ID
INVOICE_DATE
EMPLOYEE_ID
COIN_ID
DELIVERY_ID
8111
11011
15 May 2021
emp103
7111
511
8112
11013
15 May 2021
emp101
7116
512
8113
11012
17 May 2021
emp101
7112
513
8114
11015
17 May 2021
emp102
7111
514
8115
11011
17 May 2021
emp102
7115
515
8116
11015
18 May 2021
emp103
7115
516
8117
11012
19 May 2021
emp105
7112
517
8118
11013
19 May 2021
emp105
7112
517
COIN_RETURNS TABLE
RETURN_ID
RETURN_DATE
REASON
CUSTOMER_ID
COIN_ID
EMPLOYEE_ID
ret001
25 May 2021
Customer not satisfied with product
11011
7116
emp101
ret002
25 May 2021
Product missing part
11013
7114
emp103
COIN TABLE
COIN_ID
PRODUCT
PRICE
QTY
7111
1oz Gold Kruger Rand
R 5 999
10
7112
1oz Silver Kruger Rand
R 12 999
8
7113
Gold Big 5 Uncirculated
R 15 999
8
7114
Silver Big 5 Pack
R 7 999
5
7115
1oz Gold Palaeontology
R 11 999
15
7116
1oz Silver Palaeontology
R 7 999
12
COIN_DELIVERY TABLE…
Chapter 8 Solutions
A Guide to SQL
Ch. 8 - Prob. 1RQCh. 8 - Prob. 2RQCh. 8 - Prob. 3RQCh. 8 - Prob. 4RQCh. 8 - Prob. 5RQCh. 8 - Prob. 6RQCh. 8 - Prob. 7RQCh. 8 - Prob. 8RQCh. 8 - Prob. 9RQCh. 8 - In PL/SQL, how do you assign variables the same...
Ch. 8 - Prob. 11RQCh. 8 - Prob. 12RQCh. 8 - Prob. 13RQCh. 8 - Prob. 14RQCh. 8 - Prob. 15RQCh. 8 - Prob. 16RQCh. 8 - Prob. 17RQCh. 8 - Prob. 18RQCh. 8 - Prob. 19RQCh. 8 - Prob. 20RQCh. 8 - Prob. 21RQCh. 8 - Prob. 22RQCh. 8 - Prob. 1TDCh. 8 - Prob. 2TDCh. 8 - Prob. 3TDCh. 8 - Prob. 4TDCh. 8 - Prob. 5TDCh. 8 - Prob. 6TDCh. 8 - Prob. 7TDCh. 8 - Prob. 8TDCh. 8 - Prob. 9TDCh. 8 - Prob. 10TDCh. 8 - Prob. 1CATCh. 8 - Prob. 2CATCh. 8 - Prob. 3CATCh. 8 - Prob. 4CATCh. 8 - Prob. 5CATCh. 8 - Prob. 6CATCh. 8 - Prob. 7CATCh. 8 - Prob. 9CATCh. 8 - Prob. 1SCGCh. 8 - Prob. 2SCGCh. 8 - Prob. 3SCGCh. 8 - Prob. 4SCGCh. 8 - Prob. 5SCGCh. 8 - Prob. 6SCGCh. 8 - Prob. 7SCGCh. 8 - SQL includes many numerical functions. Two of...
Knowledge Booster
Similar questions
- Download return data for your choice of stock from Yahoo Finance - closing prices from 20 September 1991. Add the stock to the capm file. Adapt the R code available in the folder to your stock and replicate the analysis.arrow_forwardIn cell C10, enter a database function to display the date of the apartment that had the oldest remodel date based on the filtered data. Format the result with Short Date format.arrow_forwardExplain why it would be preferable to use a DATE data type to store date data instead of a character data type.arrow_forward
- 1. The timeclock.txt file contains the hours worked data for every employee as well as the shift they worked. The layout for the file is as follows: EMPLOYEE NUMBER, HOURS WORKED, SHIFT 2. The personnel.txt file contains the names of all employees and their hourly pay rates. The layout for the file is as follows: EMPLOYEE NUMBER, EMPLOYEE NAME, PAY RATE Note: Both the timeclock.txt and payroll.txt files are pre-sorted by EMPLOYEE NUMBER in ascending order. Business Rules 1. For hours <= 40, the employee gross pay is: HOURS WORKED PAY RATE 2. For hours> 40, the employee gross pay is: HOURS WORKED PAY RATE 1.5 3. For shift 3, add $1 per hour to the employee pay rate The program should: 1. Download both input files in the same folder that you will create your .py program. 2. Read both input files together. 3. Match the input files by the EMPLOYEE NUMBER. 4. For each record in the timesheet.txt file, write a record in a new output file named payroll,txt based on the business rules…arrow_forwardTask B. Import the data shown in pictures into the two tables created.arrow_forwardUS gun murders by state for 2010 Description: Gun murder data from FBI reports. Also contains the population of each state. Usage: data(murders) Format: An object of class "data.frame". Details: state. US state abb. Abbreviation of US state region. Geographical US region population. State population (2010) total. Number of gun murders in state (2010) 2. Extract variable names. 2. Display structure of murders dataset. 3. Write code to show the number of states per region.arrow_forward
- List all the course information and the studentswho took the courses. If the course has no student,it should be still in the output.arrow_forwardQuestion 2: implement get_athletes() function and return a list of athletes* Requirement: the information for an athlete should include name, country,* picture path and the game name (column name: gamename) that the athlete will attend.* Hint: Use selecte statement for inner join* Reference: Week 2*/function get_athletes() { //implement your codes here // return $athletes;} ?>arrow_forwardi want to insert the 2 csv into a database lifespan.csv Ref_Date,GEO,SEX,AGE,Vector,Coordinate,Value1992/1994,Canada,Both sexes,At birth,v52302196,1.1.1,78.01993/1995,Canada,Both sexes,At birth,v52302196,1.1.1,78.01994/1996,Canada,Both sexes,At birth,v52302196,1.1.1,78.2 popolationtest.csv place,population,lat,lon St. John's (N.L.),208.4,47.5605413, -52.71283150000001 Halifax (N.S.),408.7,44.6488625, -63.5753196 Moncton (N.B.)[1],144.9,46.1013902, -64.8213793 Saint John (N.B.),127.9,45.2733153, -66.0633081 Saguenay, 160.2,48.4280529, -71.0684923 Quebec (Que.),791.9,46.8273212, -71.2349247 ============= its always shows error ,i cant understand whyarrow_forward
- Question 13 Given the following declaration of records and the name of the records, write the full program to create two records and assign values based on the following details.table parttime stname(ahmed hassan) , stadress(Dubai)stphone(052772711)CGPA(3.56) Question13 table 2 table name fulltime stname(nuha Ali)stadress(abudhabi)stphone(0542227222)CGPA(3.88)arrow_forwardIs it possible to shorten the time required to reprogramme views?arrow_forward● Create a python file called database_manip.py. Write the code to do the following tasks: ○ Create a table called python_programming. ○ Insert the following new rows into the python_programming table: id name grade 55 Carl Davis 61 66 Dennis Fredrickson 88 77 Jane Richards 78 12 Peyton Sawyer 45 2 Lucas Brooke 99 ○ Select all records with a grade between 60 and 80. ○ Change Carl Davis’s grade to 65. ○ Delete Dennis Fredrickson’s row. ○ Change the grade of all people with an id below than 55.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology PtrNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:CengageCOMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L