This questions uses SQL

Below are the tables that will be used.

CREATE TABLE `Student`( `s_id` VARCHAR(20), `s_name` VARCHAR(20) NOT NULL DEFAULT '', `s_birth` VARCHAR(20) NOT NULL DEFAULT '', `s_sex` VARCHAR(10) NOT NULL DEFAULT '', PRIMARY KEY(`s_id`) );

insert into Student values('01' , ' Cobb' , '1990-01-01' , ' Male'); insert into Student values('02' , ' Arthur', '1990-12-21' , ' Male'); insert into Student values('03' , 'Ariadne' , '1990-05-20' , 'Female'); insert into Student values('04' , 'Eames' , '1990-08-06' , 'Male'); insert into Student values('05' , 'Mal' , '1991-12-01' , 'Female'); insert into Student values('06' , 'Blonde' , '1992-03-01' , 'Female'); insert into Student values('07' , 'Saito' , '1989-07-01' , 'Male'); insert into Student values('08' , 'Miranda' , '1990-01-20' , 'Female');

CREATE TABLE `Course`( `c_id` VARCHAR(20), `c_name` VARCHAR(20) NOT NULL DEFAULT '', `t_id` VARCHAR(20) NOT NULL, PRIMARY KEY(`c_id`) ); insert into Course values('01' , 'Math' , '02'); insert into Course values('02', 'French', '01'); insert into Course values('03' , 'Art', '03');

CREATE TABLE `Teacher`( `t_id` VARCHAR(20), `t_name` VARCHAR(20) NOT NULL DEFAULT '', PRIMARY KEY(`t_id`) ); insert into Teacher values('01', 'Frank'); insert into Teacher values('02', 'Einstein'); insert into Teacher values('03', 'Newton');

CREATE TABLE `Score`( `s_id` VARCHAR(20), `c_id` VARCHAR(20), `s_score` INT(3), PRIMARY KEY(`s_id`,`c_id`) ); insert into Score values('01' , '01' , 80); insert into Score values('01' , '02' , 90); insert into Score values('01' , '03' , 99); insert into Score values('02' , '01' , 70); insert into Score values('02' , '02' , 60); insert into Score values('02' , '03' , 80); insert into Score values('03' , '01' , 80); insert into Score values('03' , '02' , 80); insert into Score values('03' , '03' , 80); insert into Score values('04' , '01' , 50); insert into Score values('04' , '02' , 30); insert into Score values('04' , '03' , 20); insert into Score values('05' , '01' , 76); insert into Score values('05' , '02' , 87); insert into Score values('06' , '01' , 31); insert into Score values('06' , '03' , 34); insert into Score values('07' , '02' , 89); insert into Score values('07' , '03' , 98);

What command query will show the below table result.

Find the students who fail exam(s), show their name and the number of courses they failed. (fail: score 60). Hint: Use GROUP BY to group students. Your result table should look like this: StuName NumFailed Eames Blonde 2