Answered step by step
Verified Expert Solution
Question
1 Approved Answer
table name, schema name and column name could be imaginary. i just need a format to do it in sql? 1. select distinct instStates from
table name, schema name and column name could be imaginary. i just need a format to do it in sql? 1. select distinct instStates from institution ; order by instStates this is the way I want it . thanks!! Select Queries 1. Display all distinct states from the Institution table in alphabetical order. 2. Display all distinct rates from the loan table in descending order. 3. Display the Statement Pay method with the count of the number of records using that type. 4. Display all loan rates with their associated average begin value. Make sure to only include records whose average is greater than or equal to 20000.00. Modification Query Increase the loan begin values in the Loan table by 1.35 for all records whose loan rate is less than 12. Make sure to use a loan increase variable for the 1.35 and a loan rate variable for the 12. When using a select to show all to be modified records, use only 1 select statement and a where clause to iter. So, you show all applicable records in the results pane. Do the same for after. Adding the Example table Add a new schema and table called ClassEx.Example: CREATE SCHEMA ClassEx CREATE TABLE ClassEx. Examples Example ID int NOT NULL, Test int NOT NULL, CONSTRAINT ExamplePK PRIMARY KEY (ExampleID) 3 Inserting records into the Example table Insert the following 7 records into the ClassEx.Example table using 1 insert statement. When using a select to show all added records, use only 1 select statement. So, you show all applicable records in the results pane. Examples 2 Test 1 3 2 1 2 1 Delete Query Delete all records from Example that have test = 1; When using a select to show all to be deleted records, use only 1 select statement and a where clause to filter. So, you show all applicable records in the results pane. 1-line Removal Query Use one line of code to remove all records from the Example table, leaving the table itself still in the database. Make sure to show no results for the after portion. 1-line Remove Table Query Use one line of code to remove the Example table from the database completely. Try to display the records in the table and show the error for the after portion
table name, schema name and column name could be imaginary. i just need a format to do it in sql?
1.
select distinct instStates
from institution ;
order by instStates
this is the way I want it . thanks!!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started