17. Demonstrate your understanding of a SELECT clause, FROM clause and a SELECT statement by: Select...

 

Transcribed Image Text:

17. Demonstrate your understanding of a SELECT clause, FROM clause and a SELECT statement by: Select a table in a database, write a query.Run your query. Label the parts of your query SELECT clause, FROM clause 1 - - 18. Use arithmetic in the SELECT clause by: - - - - - - and SELECT statement Screenshot of code from Application Express's Command Line {no extra white space} Screenshot of code results {no extra white space} Select a table in a database, write a query that includes in the SELECT clause: Column/s from the table, 5 Pure math (example: 1+2), and Math against a column Explain what you did and why you chose the elements that you did Screenshot of code from Application Express's Command Line {no extra white space} Screenshot of code results {no extra white space} 19. Employees deserve a raise {use arithmetic in the SELECT clause}: Select a table in a database 2023 esser Drake that contains people and salary, write a query showing an increase in pay. You will select the table and the percent increase. In the query include: Selected information about the employee Current salary oration Salary with increase - column heading communicates increase amount you selected Screenshot of code from Application Express's Command Line (no extra white space} Screenshot of code results {no extra white space} Screensh 17. Demonstrate your understanding of a SELECT clause, FROM clause and a SELECT statement by: Select a table in a database, write a query.Run your query. Label the parts of your query SELECT clause, FROM clause 1 - - 18. Use arithmetic in the SELECT clause by: - - - - - - and SELECT statement Screenshot of code from Application Express's Command Line {no extra white space} Screenshot of code results {no extra white space} Select a table in a database, write a query that includes in the SELECT clause: Column/s from the table, 5 Pure math (example: 1+2), and Math against a column Explain what you did and why you chose the elements that you did Screenshot of code from Application Express's Command Line {no extra white space} Screenshot of code results {no extra white space} 19. Employees deserve a raise {use arithmetic in the SELECT clause}: Select a table in a database 2023 esser Drake that contains people and salary, write a query showing an increase in pay. You will select the table and the percent increase. In the query include: Selected information about the employee Current salary oration Salary with increase - column heading communicates increase amount you selected Screenshot of code from Application Express's Command Line (no extra white space} Screenshot of code results {no extra white space} Screensh