1. Suppose a database table named Address contains fields named City and State. Write an SQL SELECT statement that combines these fields into a new field named CityState. 2. Suppose a database table named Students contains the fields FirstName, LastName, and IDNumber. Write an SQL SELECT statement that retrieves the IDNumber field for all records that have a Last Name equal to "Ford". 3. Write an SQL query that retrieves the ID, Title, Artist, and Price from a database table named Albums. The query should sort the rows in ascending order by Artist.

SELECT column1, column2 FROM table1, table2 WHERE column2='value' is the syntax. In the SQL query above: The SELECT phrase designates one or more columns to be retrieved; to specify more than one column, separate column names with a comma.

What is SELECT statements?

A database table's records are retrieved using a SQL SELECT statement in accordance with criteria specified by clauses (such FROM and WHERE). The syntax is as follows:
The SQL query mentioned above:

SELECT column1, column2 FROM table1, table2 AND column2='value';

Use a comma and a space to separate the names of several columns when specifying them in the SELECT clause to get one or more columns. The wild card * will retrieve all columns (an asterisk).
A table or tables to be queried are specified in the FROM clause. If you're specifying multiple tables, place a comma and a space between each table name.
Only rows in which the designated column contains the designated value are chosen by the WHERE clause. Using the syntax WHERE last name='Vader', the value is enclose in single quotes.
The statement terminator is a semicolon (;). Technically, if you only transmit one statement to the back end, you don't need a statement terminator; if you send many statements, you need. It's preferable to include it.

To Learn more About SELECT phrase refer to:

https://brainly.com/question/26047758

#SPJ4