Reflections on a interview question

xiaoxiao2021-03-06  41

Three? Table, want ??? All?

Example: STD Table STD_ID STD_NAME0001 Alex0002 Bill0003 CLITON0004 DUKE

Course Table Course_id course_name2001 English2002 Math2003 Physics

SCORE Table STD_ID Course_id score0001 2001 810002 2001 910001 2003 240003 2002 620001 2002 54

Out: Alex ENGLISH 81ALEX MATH 54ALEX Physics 91 thinks half a day, no? Thinking, estimate? Having, in, exists will be used? Opportunity to take a look. 1. Out of the students? The name of the student is? Is it more than ??? There are a lot of common and IN, so I can solve it with in ?? Select std_name, std_id from stdwhere std_id not in (SELECT STD_ID FROM SCOR)

2. Out? All the names of the students,? Is it compared? Ma? = std.std_id and course_id = course.course_id))))))

转载请注明原文地址:https://www.9cbs.com/read-69780.html

New Post(0)