Question: Note!!!!: Need in SQLLITE 1. Create a Database names as Test/your own choice 2. Create at least one table 3. Write down the SQL queries
Note!!!!: Need in SQLLITE
1. Create a Database names as Test/your own choice
2. Create at least one table
3. Write down the SQL queries of the following tasks and provide the screenshots of your
output.
a. Create the Database
b. Create the Table query
c. show all the data from the table and show one specific column from your table
d. Show only unique data from any one of the columns.
e. Insert the data into your database
f. Show the one record of the table using where clause.
g. Update the record of table using update command
h. Add one column in your table
i. Delete the one record from your table
j. Show the minimum value from your table using the MIN function
k. Show the maximum value from your table using the MIN function
l. Show the Average value from your table using the MIN function
m. Count the number of entries of table using the COUNT function
n. Display the range of values using the Between clause
o. Display some specific values of the table using the like operator
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
