ArBS86Ge

1#CreateTable=====================================================================
2DROP TABLE IF EXISTS `students`;
3
4CREATE TABLE `students`(
5id INTEGER PRIMARY KEY,
6firstName VARCHAR(30) NOT NULL,
7lastName VARCHAR(30) NOT NULL);
8
9#InsertDataIntoTable=====================================================================
10INSERT INTO `students` (id, firstName, lastName)
11VALUES
12('1', 'Aila', 'Rogers'),
13('2', 'Sahil', 'Walter'),
14('3', 'Hisham', 'Ochoa'),
15('4', 'Stacy', 'Sheppard'),
16('5', 'Jaydn', 'Cabrera'),
17('6', 'Karl', 'Rosales'),
18('7', 'Lianne', 'Dodd'),
19('8', 'Mari', 'Terrell'),
20('9', 'Maisie', 'Tillman'),
21('10', 'Aqeel', 'Key'),
22('11', 'Lianne', 'Ochoa'),
23('12', 'John', 'Smith'),
24('13', 'Konrad', 'Delarosa'),
25('14', 'Sue', 'Doherty'),
26('15', 'John', 'Harrell');
27
28
29#CountData=====================================================================
30SELECT COUNT(*) as FirstNameWithJohn
31FROM students
32WHERE firstName = 'John';
33
34#TheAnswerisHere===============================================================
35#FirstNameWithJohn    
36#-----------------
37#2