Knowee
Questions
Features
Study Tools

Write a query to display the owner_name, address and contact_number of the buildings which does not have an email_address. Display the records in ascending order based on their owner_name.

Question

Write a query to display the owner_name, address and contact_number of the buildings which does not have an email_address. Display the records in ascending order based on their owner_name.

🧐 Not the exact question you are looking for?Go ask a question

Solution

Sure, here is the SQL query you asked for:

SELECT owner_name, address, contact_number
FROM buildings
WHERE email_address IS NULL
ORDER BY owner_name ASC;

Here's a step-by-step breakdown of the query:

  1. SELECT owner_name, address, contact_number: This part of the query selects the columns that you want to display in your result, which are owner_name, address, and contact_number.

  2. FROM buildings: This part of the query specifies the table from which to retrieve the data, which is the buildings table.

  3. WHERE email_address IS NULL: This part of the query is the condition that filters the records. It only selects the records where the email_address is not provided (i.e., it is NULL).

  4. ORDER BY owner_name ASC: This part of the query sorts the result in ascending order (ASC) by the owner_name. If you wanted to sort the results in descending order, you would use DESC instead of ASC.

This problem has been solved

Similar Questions

Write a query to display the owner_name and mail id in which the string should end before the '@' symbol. Display the details of the buildings which are having the  email address and give an alias name as 'email_name' and display it in ascending order based on owner name

Write a query to display the owner_name and contact_number of all building, Display the records in ascending order based on owner_name.Note:1. Display only the column named ‘owner_name’ and ‘contact_number’ present in the building table.2. Order by is mandatory

Write a query to display all the details of the buildings, whose building type name contains a letter 'e' but do not contain a letter 'a'. Display the records in descending order based on their owner_name.Note: Use 'Minus'Note:1. Display all the details of the buildings contains a letter 'e' but do not contain a letter 'a'.2. Order by is mandatory. 3. Use Minus.4. Compare your executed result with the sample output given below.Submit

Write a query to display all the details of the buildings whose owner name contains 'di' in ascending order based on the owner name of the building.Note:1. Display all the columns from the building table whose owner_name contains “di” from building table.2. Order by is mandatory3. Compare your executed result with the sample output given below.

Write a query to display the entire details of the 'building' whose owner_name starts with the letter 'M', Display the records in ascending order based on their owner_name.Note:1. Display all the columns present in the building table.2. Specify the condition and retrieve the correct rows in the result(condition need to be specified on owner_name column).3. You can compare your executed result with the sample output given below.4. Order by is mandatorySample output: [Only few records are shown here]

1/3

Upgrade your grade with Knowee

Get personalized homework help. Review tough concepts in more detail, or go deeper into your topic by exploring other relevant questions.