Basis Data Membuat from tb_nilai siswa

Basis  Data                                                                

> SELECT SUM(nilai) From tb_nilai;

> SELECT COUNT(nilai) From tb_nilai;

>SELECT  MAX(nilai) From tb_nilai;

>SELECT  MIN(nilai) From tb_nilai;

>SELECT  AVG(nilai) From tb_nilai;

-----------------------------------------------------------------------------------------------------------

MariaDB [(none)]> use db_smk;

Database changed

MariaDB [db_smk]> create table tb_nilai(

    -> nis int(10)not null,

    -> nama varchar(50)not null,

    -> kelas varchar(10)not null,

    -> nilai int(5)not null,

    -> primary key(nis));

Query OK, 0 rows affected (0.005 sec)

MariaDB [db_smk]> insert into tb_nilai values('1001','Aan','XI RPL','85');

Query OK, 1 row affected (0.049 sec)

MariaDB [db_smk]> insert into tb_nilai values('1002','Iin','XI RPL','90');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> insert into tb_nilai values('1003','Uun','XI RPL','92');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> insert into tb_nilai values('1004','Een','XI RPL','89');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> insert into tb_nilai values('1005','Oon','XI RPL','93');

Query OK, 1 row affected (0.002 sec)

MariaDB [db_smk]> select * from tb_nilai;

+------+------+--------+-------+

| nis  | nama | kelas  | nilai |

+------+------+--------+-------+

| 1001 | Aan  | XI RPL |    85 |

| 1002 | Iin  | XI RPL |    90 |

| 1003 | Uun  | XI RPL |    92 |

| 1004 | Een  | XI RPL |    89 |

| 1005 | Oon  | XI RPL |    93 |

+------+------+--------+-------+

5 rows in set (0.000 sec)

MariaDB [db_smk]> SELECT SUM(nilai) FROM tb_nilai;

+------------+

| SUM(nilai) |

+------------+

|        449 |

+------------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT COUNT(*) FROM tb_nilai;

+----------+

| COUNT(*) |

+----------+

|        5 |

+----------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT COUNT(*) FROM tb_nilai WHERE nilai >90;

+----------+

| COUNT(*) |

+----------+

|        2 |

+----------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT MAX(nilai) FROM tb_nilai;;

+------------+

| MAX(nilai) |

+------------+

|         93 |

+------------+

1 row in set (0.000 sec)

ERROR: No query specified

MariaDB [db_smk]> SELECT MIN(nilai) FROM tb_nilai;

+------------+

| MIN(nilai) |

+------------+

|         85 |

+------------+

1 row in set (0.000 sec)

MariaDB [db_smk]> SELECT AVG(nilai) FROM tb_nilai;

+------------+

| AVG(nilai) |

+------------+

|    89.8000 |

+------------+

1 row in set (0.000 sec)