Write a query to display the owner name and the length of the owner's name of the buildings. Display the records in ascending order based on owner name. Give an alias as name_length to the length of the owner names.Use the inbuilt function length().

Sure, here is the SQL query you asked for:

SELECT owner_name, LENGTH(owner_name) AS name_length
FROM buildings
ORDER BY owner_name ASC;

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

1. SELECT owner_name, LENGTH(owner_name) AS name_length: This part of the query is selecting two columns. The first is the owner_name column. The second is the length of the owner_name, which is calculated using the LENGTH() function. The AS name_length part is giving this column an alias, or a different name, which is name_length.

2. FROM buildings: This part of the query is specifying the table that we are selecting the data from, which is the buildings table.

3. ORDER BY owner_name ASC: This part of the query is ordering the results by the owner_name column in ascending order. If you wanted to order the results in descending order, you could use DESC instead of ASC.

Assuming you are using SQL, the query would look something like this:

SELECT owner_name, LENGTH(owner_name) AS name_length
FROM buildings
ORDER BY owner_name ASC;

Here's the step by step breakdown:

1. SELECT owner_name, LENGTH(owner_name) AS name_length: This line is selecting two columns. The first is the owner_name column. The second is the length of the owner_name, which is calculated using the LENGTH() function. The AS name_length part is giving this calculated column a name, or alias, of name_length.

2. FROM buildings: This line is specifying the table that we are selecting the data from, which in this case is the buildings table.

3. ORDER BY owner_name ASC: This line is ordering the results by the owner_name column in ascending order. If you wanted to order the results in descending order, you could use DESC instead of ASC.