create-table-dari-query-select.sql

#author          : Agung Pambudi
#email           : [email protected]
#version         : 0.4
#
#
#==============================================================================
#                                   _         _ _
# ___ ___ _ _ ___ ___ ___ ___ _____| |_ _ _ _| |_|  ___ ___ _____
#| .'| . | | |   | . | . | .'|     | . | | | . | |_|  _| . |     |
#|__,|_  |___|_|_|_  |  _|__,|_|_|_|___|___|___|_|_|___|___|_|_|_|
#    |___|       |___|_|


DROP TABLE datautama;

CREATE TABLE datautama SELECT kodebarang, namawarung, pesanulang FROM barang_20210831;

SELECT kodebarang, AVG(pesanulang) FROM datautama GROUP BY kodebarang;

DROP TABLE datautama;