Write an SQL statement that combine the courses and teachers tables to query the n ames of all courses taught by teachers whose nationality is USA. Table Definition: teachers Column Name Туре Comments...


SQL QUERY!!


Write an SQL statement that combine the courses and teachers tables to query the n<br>ames of all courses taught by teachers whose nationality is USA.<br>Table Definition: teachers<br>Column Name<br>Туре<br>Comments<br>id<br>int unsigned<br>primary key<br>varchar<br>teacher's name<br>name<br>email<br>varchar<br>teacher's email<br>age<br>int<br>teacher's age<br>country<br>varchar<br>teacher's nationality<br>

Extracted text: Write an SQL statement that combine the courses and teachers tables to query the n ames of all courses taught by teachers whose nationality is USA. Table Definition: teachers Column Name Туре Comments id int unsigned primary key varchar teacher's name name email varchar teacher's email age int teacher's age country varchar teacher's nationality
Table definition: courses<br>column name<br>type<br>comment<br>id<br>int unsigned<br>primary key<br>name<br>varchar<br>course name<br>student_count<br>int<br>student count<br>created_at<br>datetime<br>course creation time<br>teacher_id<br>int unsigned<br>teacher id<br>• If the column country in teachers is null, the data returned is also null<br>• If the column teacher id in courses is nullI, then the returned data is also null<br>

Extracted text: Table definition: courses column name type comment id int unsigned primary key name varchar course name student_count int student count created_at datetime course creation time teacher_id int unsigned teacher id • If the column country in teachers is null, the data returned is also null • If the column teacher id in courses is nullI, then the returned data is also null

Jun 06, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here