Write SQL queries to answer the following questions: What are the names of the course(s) that student Altvater took during the s
emester I-2018? List the names of the students who have taken at least one course that Professor Collins is qualified to teach. List the names of the students who took at least one course with ""Syst"" in its name during the semester I-2018.
1 answer:
Answer:
See explanations
Explanation:
Consider the following Venn diagram to retrieve the name of course that student Altvater took during semester I-2015.
• In above Venn diagram inner Ellipse represent the subquery part, this subquery part select the Student ID from STUDENT table.
• Second sub query is used to determine the SectionNo of all student whose studentID retrived in the first subquery
• Finally the main query displays the CourseName from COURSE table.
You might be interested in
Answer:
<em>The direction of ball will be Number 4 (as can be seen in attached picture) ---- the path of ball will be making some angle when it leaves the tube. </em>
Explanation:
The question is incomplete. So the picture, which is missing in question, is attached for your review.
As it can be seen in the picture, the ball coming out of the tube will have two components of velocity. One is along the length of tube (because ball is moving in that direction and is coming out from the hole), other is velocity component will be perpendicular to the tube (because the ball is made to move in that direction as the tube is rolling on the surface).
<em>So, taking the resultant of two vectors of velocity, the resultant direction of ball will be Number 4 (as can be seen in attached picture) ---- the path of ball will be making some angle when it leaves the tube. </em>
