Current location - Education and Training Encyclopedia - Resume - SQL creates student table (student), course, class table (class) and course selection table (XK), and I can reward QB for writing it correctly.
SQL creates student table (student), course, class table (class) and course selection table (XK), and I can reward QB for writing it correctly.
1, select DISTINCT Sdept from the students.

2. Select Count (different Cpno)

course

Where CNAME = "English";

3, create a table Student2

(SNO character (9) primary key,

SNAME CHAR(20) is unique,

Ssex CHAR(2)，

Sbirthday SMALLINT，

Sdept CHAR(20)

);

Related articles
  • High school students' resume model essay
  • What is the relationship between Feng Changge and Feng Changjin?
  • Yantai postal code
  • Are there any actors who imitate the film and television artist Ethan?
  • When Song Zu Ying grew up, I became. Where did you take it?
  • Other information of Harbin Kindergarten Normal School
  • Hu resume
  • Which city does Qingyang County belong to?
  • The reason why Qujing Hou Wenli was investigated.
  • How to write a resume of a supervisor

    • copyright 2024 Education and Training Encyclopedia All rights reserved