Write a query to insert any 3 records into the 'building' table.
Question
Write a query to insert any 3 records into the 'building' table.
Solution
Sure, here is an example of how you can insert 3 records into the 'building' table. Please replace the 'column1', 'column2', etc. with the actual column names of your 'building' table and 'value1', 'value2', etc. with the values you want to insert.
INSERT INTO building (column1, column2, column3)
VALUES ('value1', 'value2', 'value3'),
('value4', 'value5', 'value6'),
('value7', 'value8', 'value9');
In this query, we are inserting 3 rows into the 'building' table. Each row is represented by a set of values inside parentheses. The values are separated by commas. The sets of values are also separated by commas.
Similar Questions
Write a query to insert any 3 records into the 'building' table.Note:1. This ‘building’ table got foreign key reference. Already building_type table got below records in it. You no need to insert any new records into building_type table. Please insert records into building table alone by referring the below building_type_id.2. You can provide any values to the building id, owner_name, address, contact_number and email_address column. But for the building_type_id column you must refer to the values specified in the building_type id column only.3. Insert only 3 records into the building table
Write a query to create 'building' table.
Write a query to display the building_type name and the number of buildings under the type which has maximum number of buildings. Give an alias name for number of buildings as number_of_buildings and for building name as building_name. If there are multiple records sort in ascending order by building_name.Note:1. Display only the building_type name and no. of buildings in building_type table with the condition having maximum no. of buildings.2. Use Joins3. Tables involved are building and building_type4. Order by is mandatory. 5. Specify the alias name without any mistake.6. Compare your executed result with the sample output given below.
Write a query to display the building owner name ,address and number of connections present in each building. Display the records in ascending order based on owner name.Give an alias name as connection_count.Note:1. Display only the building owner_name ,address and number of connections.2. Use Joins3. Tables involved building, building_type, meter4. Specify the alias name without any mistake.5. Order by is mandatory. 6. Compare your executed result with the sample output given below.
Write a query to display all the building details in which building_type named ‘Library’. Display the records in ascending order based on their owner_name.Note:1. Display all the column present in the building table where building_type name is ‘Library’. Use subqueries to achieve this.2. Tables involved are building_type and building3. Order by is mandatory.
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.