1) Menghitung item yang harus di ba

1) Menghitung item yang harus di bayarkan oleh customer dapat di lihat dengan query berikut
SELECT order_id,SUM(qty*price)FROM item_level
GROUP BY id;
*Id di sini menandakan sebuah item
Query berikut untuk menampilkan order id dan total per item di table

Hasil (Inggris) 1:

1) Calculate items which must be paid by the customer can be seen with the following querySELECT order_id, SUM (qty * price) FROM item_levelGROUP BY id;* Id here indicate an itemThe following query to display the order id and total per item in table

Hasil (Inggris) 2:

1) Calculate the items that should be paid by the customer can be viewed with the following query
SELECT order_id, SUM (qty * price) FROM item_level
GROUP BY id;
* Id here signifies an item
following query to display the order id and the total per item on the table