new-student-dept-amount-table.sql

USE university;

DROP TABLE IF EXISTS students;

CREATE TABLE IF NOT EXISTS students (
    student_id INTEGER,
    name VARCHAR(55),
    admitted_at DATE,
    age INTEGER,
    grade DECIMAL(2,1),
    entry_date DATETIME,
    department VARCHAR(55),
    amount_paid DECIMAL(8,2)
);

INSERT INTO students (student_id, name, admitted_at, age, grade, entry_date, department, amount_paid)
VALUES (1, 'Oyinda Welathy', '2015-09-01', 27, 3.8, '2015-09-01 13:21:59', 'Biochemistry', 29200),
       (2, 'Miriam Abubakar', '2017-09-01', 24, 4.0, '2017-09-01 11:13:51', 'Biochemistry', 31350), 
       (3, 'Dorcas Roberts', '2016-09-01', 24, 3.7, '2016-09-01 14:19:23', 'Sociology', 30000),
       (4, 'Ayomide Titilope', '2015-09-01', 25, 4.0, '2015-09-01 10:11:34', 'Physics', 26410), 
       (5, 'Emeka Jude', '2014-09-01', 24, 3.8, '2014-09-01 15:12:21', 'Biochemistry', 29200),
	   (6, 'Caroline Obi', '2013-09-01', 27, 3.1, '2013-09-01 12:12:36', 'Electrical Engineering', 42360),
	   (7, 'Franklin Oladele', '2019-09-01', 18, 3.9, '2019-09-01 10:00:00', 'Sociology', 31350),
	   (8, 'Kola Ola', '2013-09-01', 28, 4.0, '2013-09-01 11:10:21', 'Electrical Engineering', 26000), 
       (9, 'Emmanuel Ovi', '2016-09-01', 23, 3.1, '2016-09-01 11:59:59', 'Statistics', 42360),
	   (10, 'Kareem Musa', '2016-09-01', 24, 3.3, '2016-09-01 10:11:21', 'Statistics', 26890),
	   (11, 'Mustapha Ahmed', '2016-09-01', 24, 3.9, '2016-09-01 15:11:20', 'Statistics', 27110),
	   (12, 'Femi Akin', '2017-09-01', 24, NULL, '2017-09-01 09:11:32', 'Physics', 26410);