Find the SQL statement to write the database

Select Courses. Course name, course. Teacher's name from student, course, student selection.

where students. Student ID = Student Enrollment Course. Student ID and Course. Course number = student enrollment of the course. Course number.

and students. Student ID='0001'

select students. Student number, count (student chooses courses.) Student ID) as number of elective courses from student, student electives.

where students. Student ID = Student Enrollment Course. Student ID=

group by Student. Student ID=

Query with table If there is a query with a right table, it is OK.

I'm not familiar with it yet, so I'm learning slowly.

1. Select Select * from table1 where range.

2. Insert: insert into table1(field1,field2) values(value1,value2).

3. Delete: Delete from table1 where range.

4. Update: update table1 set field1=value1 where range.

5. Sorting: select * from table1 order by field1, field2 [desc].

6. Total: select count as totalcount from table1

7. Summation: select sum(field1) as sumvalue from table1

A few advanced query operators:

a, union operator.

The union operator derives a result table by combining two other result tables, such as table1 and table2, and eliminating any duplicate rows from the table. When all is used with union (i.e., union all), duplicate rows are not eliminated. In both cases, each row of the derived table is either from table1 or from table2.

b. Except operator.

The except operator derives a result table by including all rows that are in table1 but not in table2 and eliminating all duplicate rows. When all is used with except all, duplicate rows are not eliminated.

c, intersect operator.

The intersect operator derives a result table by including only the rows that are present in both table1 and table2 and eliminating all duplicate rows. When all is used with intersect (intersect all), duplicate rows are not eliminated.

1 select * from table name where department id = 20

2 select Employee Number, Employee Name, Department Number from Table Name where Job Type=Clerk

3 select * from table name where comm>sal

4 select * from table name where comm>(sal*.)

5 select * from table name where (department id = 10 and job type=manager) or (department id = 20 and job type=clerk).

6 select * from Table Name where Job! =manager and type of work! =Clerk and Salary, 1999

7 select job from table name where bonus != null

select * from Employee Information Table.

select Employee Number, Employee Name, Department Number from Table Name where Job Type=Clerk

select * from table name where comm>sal

14 select * from table name where name like'%m%'

15 select * from table name where name like'?m%'

Let someone else make it up, it's too much.