Insert two records in each table or use if you have already created this schema. Q#2 Display Employees Fname and salary who are males and salary is greater than equal to 1000. Q#3 Display Address of employees where salary range starting from 1000 to 2000. Q#4 Display Last name of employee that starts with A and end on B. Q#5 Display Fname of employee that starts with A and have size of 3. Like: Ali,Ans etc Q#6 Display Project name and Project number that belongs to department 1. Q#7 Display Dependent name who were not born in 2002,2003 and 2004. Q#8 Display Pno who take a time more than 3 hours and less than 10 hours. Q#9 update working hours 3 hours to 5 hours. Q#10 Delete record in Dependent who have gender Male.
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Q#1 Insert two records in each table or use if you have already created this schema.
Q#2 Display Employees Fname and salary who are males and salary is greater than equal to
1000.
Q#3 Display Address of employees where salary range starting from 1000 to 2000.
Q#4 Display Last name of employee that starts with A and end on B.
Q#5 Display Fname of employee that starts with A and have size of 3. Like: Ali,Ans etc
Q#6 Display Project name and Project number that belongs to department 1.
Q#7 Display Dependent name who were not born in 2002,2003 and 2004.
Q#8 Display Pno who take a time more than 3 hours and less than 10 hours.
Q#9 update working hours 3 hours to 5 hours.
Q#10 Delete record in Dependent who have gender Male.
Step by step
Solved in 2 steps