SQL Assignment & Interview Queries with Solutions (example) | MySQL Database part 1

Sql assignment queries with solution(answer) | mysql Database

Data Manipulation Language (DML):

SELECT: Retrieves data from a database.
INSERT: Adds new data to a table.
UPDATE: Modifies existing data in a table.
DELETE: Removes data from a table.
Data Definition Language (DDL):

CREATE: Creates database objects like tables, views, indexes, and users.
ALTER: Modifies the structure of existing database objects.
DROP: Deletes database objects.
TRUNCATE: Removes all data from a table without deleting the table structure.
Data Control Language (DCL):

GRANT: Gives users permission to perform actions on database objects.
REVOKE: Revokes permissions from users.
Common Query Clauses:

WHERE: Specifies conditions for filtering data.
ORDER BY: Sorts the results of a query.
GROUP BY: Groups data together based on specified columns.
HAVING: Filters groups based on aggregate functions.
Joining Tables:

INNER JOIN: Combines rows from two tables based on a common column.
LEFT JOIN: Includes all rows from the left table, even if there's no match in the right table.
RIGHT JOIN: Includes all rows from the right table, even if there's no match in the left table.
FULL JOIN: Includes all rows from both tables, regardless of whether there's a match.
Other Common Commands:

USE: Selects a database to work with.
SHOW: Displays information about database objects.
DESCRIBE: Provides details about the structure of a table.
COMMIT: Saves changes made to the database.
ROLLBACK: Reverts changes made to the database.

[Fitnes_Revolution]

sir i have no words to explain your work. you are amazing. i was worried about my assignment questions but after your videos i m very clear about other imp topics. thank you so much🙏

[NITINCHAVAN-vvuy]

1) show employee number, sales person (combination of first and last names of employees) unique customers for each employee number and sort the data by highest to lowest unique customers 2) show total quantities in stock . left over quantities for each product and each customer . soft the data by customer number 3) create ta les and fields 4)create table project 6) create table facility 7) create university

[AshG-tenn]

1) Calculate year wise, month name wise count of orders and year over year (YoY) percentage change. Format the YoY values in no decimals and show in % sign.
Table: Orders

[loopmasklifemaskvr]

sir this is a kind request for the rest of further questions in this assignment we are getting pressurized for the assigned thing i am very thankful for this help in my current drastic condition
much thankful
humble subscriber

[NITINCHAVAN-vvuy]

SQL Assignment Queries and Solutions with example |MySQL Database part 2

[riyagaikar]

My result gride is blank! And how to open result gride?

[AshG-tenn]

Create the view products status. Show year wise total products sold. Also find the percentage of total value for each year please

[DivyaPatkar-zh]

Group By with Aggregation functions and Having clause, Date and Time functions 1Using the OrderDetails table, identify the top 10 products (by productCode) with the highest total order quantity across all orders. what will be the ans of this question.

[chaykulkarni]

⁠sir i have uploaded Day wise assignment SQL in the DRIVE i have to submit assignments as soon as possible please upload all assignments videos
Request from subscriber
Document name : Day Wise Assignmemt SQL

[AshG-tenn]

2) Create the table emp_udf with below fields.

● Emp_ID
● Name
● DOB
Add the data as shown in below query.
INSERT INTO Emp_UDF(Name, DOB)
VALUES ("Piyush", "1990-03-30"), ("Aman", "1992-08-15"), ("Meena", "1998-07-28"), ("Ketan", "2000-11-21"), ("Sanjay", "1995-05-21");

Create a user defined function calculate_age which returns the age in years and months (e.g. 30 years 5 months) by accepting DOB column as a parameter.

[SaiNitishSaraSreenivasRao]

Hello Sir,

How do you load the file in SQL, can you tell me the steps if possible?

Your videos are very helpful

[chaykulkarni]

Sir please teach all assignments
Please share your drive link i will upload whole assignment document

[bhuvanareddy]

Sir can you please solve the remaining assignment questions