State SQL query to satisfy the requirements below:

  

• Include the following columns:
  • First Name
  • Last Name
• Return all rows from the people table where the person's last name is between B and H.
• Use the LEFT function in the where statement.

Query

____

first_name AS ____ , last_name AS ___

______

_______

WHERE

____(last_name, ____) ____ 'B' AND 'H'

Requirements

  

• Include the following columns:
  • First Name
  • Last Name
  • Personal Email Address
  • Cambrian Email Address
• Return all rows from the people table.
• The personal email address column should be the email address stored in the people table.
• The email address column should be created using a combination of the person's first name and last name.Use the following format:
  • The person's first name, a period, and their last name @hotpapa.ca
  • Example:Nathan Abourbih's email address would be n..h@hotpapa.ca
• Ensure that email addresses will never contain any uppercase characters.

Query

SELECT

______ AS ____ , last_name AS 'Last Name' , _____AS 'Personal Email Address' , _____(CONCAT(first_name, _____, _____, '@hotpapa.ca')) AS 'Cambrian Email Address'

_______

people