Tabel Nilai
Rifandi Madong
Setting
environment for using XAMPP for Windows.
Administrator@B27
C:\xampp
# mysql -u root
Welcome to the
MySQL monitor. Commands end with ; or
\g.
Your MySQL
connection id is 3
Server version:
5.1.41 Source distribution
Type 'help;' or
'\h' for help. Type '\c' to clear the current input statement.
mysql> show
databases;
+--------------------+
| Database |
+--------------------+
|
information_schema |
| cdcol |
| mysql |
| phpmyadmin |
| test |
+--------------------+
5 rows in set
(0.17 sec)
mysql> create
database 09201357_Nilaiku;
Query OK, 1 row
affected (0.03 sec)
mysql> use 09201357_Nilaiku;
Database changed
mysql> create
table UTS(
-> Nama varchar(35),
-> Kelas char,
-> Matematika int(2),
-> Agama int(2),
-> Web int(2),
-> Datbes int(2),
-> SO int(2),
-> Pancasila int(2),
-> Comnet int(2));
Query OK, 0 rows
affected (0.08 sec)
mysql> insert
into UTS values('Fandi','A','70','45','35','70','85','45','45'),
-> ('Dani','A','60','50','45','65','70','55','60'),
-> ('Bambang','B','35','45','57','90','65','75','45'),
-> ('Citra','B','55','45','60','80','90','67','70'),
-> ('Abu','B','70','70','58','67','80','35','65'),
-> ('Hasim','C','54','70','47','85','67','90','80'),
-> ('Fahri','C','60','60','70','85','89','90','55'),
-> ('Asmiyanti','C','70','70','65','85','48','70','85');
Query OK, 8 rows
affected (0.02 sec)
Records: 8 Duplicates: 0
Warnings: 0
mysql> select
* from UTS;
+-----------+-------+------------+-------+-----+--------+----+-----------+---------+
| Nama |
Kelas | Matematika | Agama | Web | Datbes | SO | Pancasila | Comnet |
+-----------+-------+------------+-------+-----+--------+----+-----------+---------+
| Fandi | A
| 70
| 45 | 35 | 70 | 85
| 45 | 45 |
| Dani |
A | 60 | 50
| 45 |
65 | 70 | 55 | 60 |
| Bambang | B
| 35 | 45
| 57 |
90 | 65 | 75 | 45 |
| Citra | B
| 55
| 45 | 60 |
80 | 90 | 67 | 70 |
| Abu |
B | 70
| 70 | 58 |
67 | 80 | 35 | 65 |
| Hasim | C
| 54 | 70
| 47 |
85 | 67 | 90 | 80 |
| Fahri | C
| 60 | 60
| 70 |
85 | 89 | 90 | 55 |
| Asmiyanti |
C | 70 | 70
| 65 |
85 | 48 | 70 | 85 |
+-----------+-------+-----------+-------+-----+--------+----+-----------+---------+
8 rows in set
(0.02 sec)
mysql> select
Nama from UTS where kelas='B';
+---------+
| Nama |
+---------+
| Bambang |
| Citra |
| Abu |
+---------+
3 rows in set
(0.00 sec)
mysql> select
sum(Matematika) from uts;
+-----------------+
| sum(Matematika)
|
+-----------------+
| 474 |
+-----------------+
1 row in set
(0.03 sec)
mysql> select
sum(Datbes) from uts where kelas='B';
+-------------+
| sum(Datbes) |
+-------------+
| 237 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
avg(Datbes) from UTS;
+-------------+
| avg(Datbes) |
+-------------+
| 78.3750 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
sum(Datbes) from uts;
+-------------+
| sum(Datbes) |
+-------------+
| 627 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
sum(Datbes)/count(*) from uts;
+----------------------+
| sum(Datbes)/count(*)
|
+----------------------+
| 78.3750 |
+----------------------+
1 row in set
(0.01 sec)
mysql> select
sum(Datbes)/count(*) as nilai_rata2 from uts;
+-------------+
| nilai_rata2 |
+-------------+
| 78.3750 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
sum(Datbes)/count(*) as nilai_rata2 from uts where kelas='C';
+-------------+
| nilai_rata2 |
+-------------+
| 85.0000 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
sum(Matematika)+sum(Agama)+sum(Web)+sum(Datbes)+sum(SO)+sum(Pancasila)
+sum(Comnet)/7 as
nilai_rata2 from uts where kelas='Fandi';
+-------------+
| nilai_rata2 |
+-------------+
| NULL |
+-------------+
1 row in set
(0.00 sec)
mysql> select
sum(Matematika)+sum(Agama)+sum(Web)+sum(Datbes)+sum(SO)+sum(Pancasila)
+sum(Comnet)/7 as
nilai_rata2 from uts where nama='Fandi';
+-------------+
| nilai_rata2 |
+-------------+
| 356.4286 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
(sum(Matematika)+sum(Agama)+sum(Web)+sum(Datbes)+sum(SO)+sum(Pan
casila)+sum(Comnet))/7
as nilai_rata2 from uts where nama='Fandi';
+-------------+
| nilai_rata2 |
+-------------+
| 56.4286 |
+-------------+
1 row in set
(0.00 sec)
mysql> select
sum(Pancasila)/count(*) as nilai_rata2_Pancasila from uts;
+-----------------------+
|
nilai_rata2_Pancasila |
+-----------------------+
| 65.8750 |
+-----------------------+
1 row in set
(0.00 sec)
mysql> select
max(Datbes) as nilai_tertinggi from uts;
+-----------------+
| nilai_tertinggi
|
+-----------------+
| 90 |
+-----------------+
1 row in set
(0.00 sec)
mysql>
Tidak ada komentar:
Posting Komentar