Item Table

Purchase Table

5. Write a query to display Tanggal_Beli, Nama_Pembeli, and Jumlah_Pembelian in the purchases table where Jumlah_Pembelian = 2 and displays Tanggal_Beli, Nama_Pembeli, Jumlah_Pembelian in the Purchase Table based on Nama_Pembeli containing the letter 'al'. (You can choose to use the Union query or Union All)

6. Write a query to display ID_Barang, Nama_Barang, Tanggal_Beli, Nama_Pembeli, and Jumlah_Pembelian where the purchase amount is the largest number.

\begin{tabular}{|l|l|} \hline Nama Field & Tipe Data \\ \hline ID_Barang & Varchar \\ \hline Nama_Barang & Varchar \\ \hline Tanggal_Terima & Datetime \\ \hline Stok_Barang & Int \\ \hline \end{tabular} \begin{tabular}{|l|l|} \hline Nama Field & Tipe Data \\ \hline ID_Pembeli & Varchar \\ \hline ID_Barang & Varchar \\ \hline Tanggal_Beli & Datetime \\ \hline Jumlah_Pembelian & Int \\ \hline Nama_Pembeli & Varchar \\ \hline \end{tabular}