rishadharis

## Created by RHB
# Your code here
print("Hello World")

- ## Created by RHB
- ~~# Your code here~~
- # Your code here
- print("Hello World")

Basic Select with Alias (BIE)

select name nama, age umur from customers

- ~~-- Code Here~~
- select name nama, age umur from customers

rishadharisvs.rishadharis

Failed Tests

Basic Ordering 1 ASC (BIE)

```
select * from transactions
```
- ~~-- Code Here~~
- select * from transactions

Failed Tests

Nama Kolom	Tipe Data	Deskripsi
id	Serial	Primary Key
type	varchar	Cara Pengambilan Data
features_type	varchar	Tipe Pengambilan Data
dati_code	integer	Kode Dati (Kota)
confirmed_cases	integer	Jumlah Kasus Covid Terkonfirmasi
recovered_cases	integer	Jumlah Kasus Covid Sembuh
death_cases	integer	Jumlah Kasus Covid Meninggal
date	date	Tanggal

Nama Kolom	Tipe Data	Deskripsi
code	integer	Kode Dati
city_name	varchar	Nama Kota
province_name	varchar	Nama Provinsi
country_name	varchar	Nama Negara

kota	confirmed_cases	recovered_cases	death_cases
Kota Tasikmalaya	10000	2000	200
Kabupaten Tasikmalaya	8000	3000	220

Basic Select (BIE)

```
-- Code here
select * from customers
```
- -- Code here
- select * from customers

rishadharisvs.rishadharis

Basic Select (BIE)

```
-- Code here
select * from customers
```
- -- Code here
- select * from customers

Failed Tests

Basic Use Case 1 (BIE)

Perusahaan bernama BIE memiliki tabel employees

Column Name	Data Type	Description
employee_id	`serial`	primary key
name	`string`	Nama Pegawai
months	`integer`	Total Bulan Bekerja
salary	`integer`	Gaji Bulanan

Buatlah query sql untuk mendapatkan daftar pegawai yang memiliki gaji di atas 5.000.000 dan sudah bekerja selama 12 bulan atau lebih. Urutkan berdasarkan gaji dari yang terbesar ke terkecil.

Contoh

input

employee_id	name	months	salary
1	rishad	10	7000000
2	haris	14	3000000
3	tomi	13	6250000
4	somi	12	7250000

output

employee_id	name	months	salary
4	somi	12	7250000
3	tomi	13	6250000

-- Code Here

# TODO: replace with your own tests (TDD), these are just how-to examples to get you started.

# Ruby/Rspec/Sequel Example:
# While the code section is pure SQL, for testing we use Ruby & Rspec.
# Sequel (https://github.com/jeremyevans/sequel) is used to setup the database and run queries.
# The connection is already made for you, use DB to access.

DB.create_table :employees do
  primary_key :employee_id
  String :name
  Integer :months
  Integer :salary
end

items = DB[:employees] # Create a dataset

# Populate the table
items.insert(:name => 'Ringo Concklin', :months => 30, :salary => 4676243)
items.insert(:name => 'Erie Couche', :months => 12, :salary => 3301125)
items.insert(:name => 'Tripp Summerlie', :months => 1, :salary => 2175831)
items.insert(:name => 'Zulema Plume', :months => 17, :salary => 3115847)
items.insert(:name => 'Vittorio Espine', :months => 12, :salary => 3500024)
items.insert(:name => 'Roz Bumphries', :months => 27, :salary => 9024845)
items.insert(:name => 'Marita De Witt', :months => 11, :salary => 4872515)
items.insert(:name => 'Peggi Gerrets', :months => 24, :salary => 4452181)
items.insert(:name => 'Baily Gulvin', :months => 17, :salary => 3493698)
items.insert(:name => 'Brnaba Dondon', :months => 9, :salary => 4682543)
items.insert(:name => 'Danell Crothers', :months => 14, :salary => 5841335)
items.insert(:name => 'Udell Worster', :months => 25, :salary => 7034337)
items.insert(:name => 'Othilia Flann', :months => 13, :salary => 6788857)
items.insert(:name => 'Jordain Canas', :months => 6, :salary => 6318979)
items.insert(:name => 'Humberto Dict', :months => 9, :salary => 4120323)
items.insert(:name => 'Mandel Blackhall', :months => 7, :salary => 8679583)
items.insert(:name => 'Clementia Sibary', :months => 13, :salary => 1193852)
items.insert(:name => 'Jodee Lexa', :months => 4, :salary => 9972163)
items.insert(:name => 'Ruthy Martina', :months => 1, :salary => 5670042)
items.insert(:name => 'Brook Aveyard', :months => 3, :salary => 6084339)
items.insert(:name => 'Robbi Thorndale', :months => 19, :salary => 6166366)
items.insert(:name => 'Lissy Stapford', :months => 12, :salary => 4390652)
items.insert(:name => 'Jen Kennally', :months => 24, :salary => 2251845)
items.insert(:name => 'Vivi Enrietto', :months => 25, :salary => 5516117)
items.insert(:name => 'Tammie McWhorter', :months => 22, :salary => 3765131)
items.insert(:name => 'Brianna Coxwell', :months => 30, :salary => 1212817)
items.insert(:name => 'Ulick Diable', :months => 20, :salary => 1315339)
items.insert(:name => 'Marshall Cuer', :months => 29, :salary => 8585830)
items.insert(:name => 'Rafaelita Ringrose', :months => 6, :salary => 6094500)
items.insert(:name => 'Geri Cullingworth', :months => 17, :salary => 8163237)
items.insert(:name => 'Arvy Christiensen', :months => 19, :salary => 6986362)
items.insert(:name => 'Zulema Eagling', :months => 18, :salary => 2432231)
items.insert(:name => 'Rosalyn Ackeroyd', :months => 28, :salary => 2146530)
items.insert(:name => 'Elfie Whether', :months => 18, :salary => 8794798)
items.insert(:name => 'Benson Burchatt', :months => 1, :salary => 2145717)
items.insert(:name => 'Rodney Alpe', :months => 18, :salary => 5556641)
items.insert(:name => 'Hedy Caso', :months => 22, :salary => 5532341)
items.insert(:name => 'Cammi Scothorn', :months => 18, :salary => 1847839)
items.insert(:name => 'Andros Pryde', :months => 6, :salary => 9309686)
items.insert(:name => 'Elyse Emlen', :months => 24, :salary => 2191111)



# calling run_sql will print the results and return them so that you can test data within them.
# if you want to test different sets of data, then its best to move this code into its own top level describe
# block. If you are only testing one set though, its better to set the results before you enter a describe block
# so that the results are presented at the top of the output.
results = run_sql

describe :test do
  it "Should return 12 items" do
    expect(results.count).to eq 12
 end
  
  it "should have all total_price values greater than or equal to 5000000" do
    expect(results.all? { |row| row[:salary] >= 5000000 }).to be true
  end
  it "total number of months they've been working for the company should be more or equal than 12 month" do
    expect(results.all? { |row| row[:months] >= 12 }).to be true
  end
  it "should order salary from largest to smallest" do
    prices = results.map {|row| row[:salary]}
    expect(prices).to eq(prices.sort.reverse)
  end
  
end


# Other tips about using run_sql:
# The SQL/code section supports multiple statements, seperated of course by a ";".
# When multiple SELECT statements are issued:
#    run_sql will return an array of arrays, unless only one SELECT statement returned results
#    INSERT and UPDATE results will not be included in the list
#    SELECT statements that return no results will not be included in the list

Failed Tests

Basic Ordering 3 Multiple Order (BIE)

Perusahaan bernama BIE memiliki tabel transactions yang memilik skema seperti dibawah ini

Column Name	Data Type
transaction_id	`serial`
date	`date`
store	`string`
total_price	`float`
customer	`string`

Buatlah query sql untuk mendapatkan semua data transaksi yang customer nya bukan null, urutkan dari nama store terlebih dahulu dari A ke Z, baru urutkan berdasarkan total_price dari terbesar ke terkecil

Contoh

input

transaction_id	date	store	total_price	customer
1	2022-01-01	BIE Store Bandung	30000	Bobi
2	2022-01-01	BIE Store Bandung	40000	Abe
3	2022-01-01	BIE Store Bandung	50000	Sude
4	2022-01-01	BIE Store Ambon	20000	Bilal

output

transaction_id	date	store	total_price	customer
4	2022-01-01	BIE Store Ambon	20000	Bilal
3	2022-01-01	BIE Store Bandung	50000	Sude
2	2022-01-01	BIE Store Bandung	40000	Abe
1	2022-01-01	BIE Store Bandung	30000	Bobi

-- Code Here

# TODO: replace with your own tests (TDD), these are just how-to examples to get you started.

# Ruby/Rspec/Sequel Example:
# While the code section is pure SQL, for testing we use Ruby & Rspec.
# Sequel (https://github.com/jeremyevans/sequel) is used to setup the database and run queries.
# The connection is already made for you, use DB to access.

DB.create_table :transactions do
  primary_key :transaction_id
  Date :date
  String :store
  Float :total_price
  String :customer
end

items = DB[:transactions] # Create a dataset

# Populate the table
items.insert(:date => '2023-01-27', :store => 'BIE Store Palembang', :total_price => 964172, :customer => 'Ruthi Pepall')
items.insert(:date => '2023-01-06', :store => 'BIE Store Jakarta', :total_price => 419689, :customer => 'Horatius McPhate')
items.insert(:date => '2022-10-16', :store => 'BIE Store Bandung', :total_price => 664220, :customer => 'Romonda Gosker')
items.insert(:date => '2023-02-22', :store => 'BIE Store Malang', :total_price => 147934, :customer => 'Hinda Maldin')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 367084, :customer => 'Cybill Upstone')
items.insert(:date => '2022-09-01', :store => 'BIE Store Jakarta', :total_price => 522890, :customer => nil)
items.insert(:date => '2023-01-12', :store => 'BIE Store Palembang', :total_price => 290499, :customer => 'Leda Soeiro')
items.insert(:date => '2022-06-30', :store => 'BIE Store Malang', :total_price => 677804, :customer => nil)
items.insert(:date => '2022-11-06', :store => 'BIE Store Malang', :total_price => 458234, :customer => 'Zaria Sinnett')
items.insert(:date => '2023-02-11', :store => 'BIE Store Jakarta', :total_price => 181251, :customer => 'Worthy Morkham')
items.insert(:date => '2022-06-02', :store => 'BIE Store Balikpapan', :total_price => 631237, :customer => 'Sonnnie Fantin')
items.insert(:date => '2023-01-08', :store => 'BIE Store Bandung', :total_price => 716369, :customer => 'Georgianna Schuricke')
items.insert(:date => '2023-02-27', :store => 'BIE Store Bandung', :total_price => 252423, :customer => 'Rutherford Nursey')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 916700, :customer => 'Daffie Traut')
items.insert(:date => '2022-10-28', :store => 'BIE Store Bandung', :total_price => 921096, :customer => 'Charmine Cabera')
items.insert(:date => '2022-11-17', :store => 'BIE Store Malang', :total_price => 805858, :customer => 'Tuck Carabet')
items.insert(:date => '2022-07-18', :store => 'BIE Store Jakarta', :total_price => 778746, :customer => 'Ted Anney')
items.insert(:date => '2022-08-17', :store => 'BIE Store Jakarta', :total_price => 810906, :customer => 'Stephie Eglin')
items.insert(:date => '2022-10-06', :store => 'BIE Store Palembang', :total_price => 631197, :customer => 'Guglielmo Yellowley')
items.insert(:date => '2023-03-12', :store => 'BIE Store Malang', :total_price => 153729, :customer => 'Woodie Glowacha')
items.insert(:date => '2022-09-23', :store => 'BIE Store Malang', :total_price => 448198, :customer => 'Tressa Dellenbach')
items.insert(:date => '2022-07-02', :store => 'BIE Store Jakarta', :total_price => 626042, :customer => 'Otha McKerton')
items.insert(:date => '2022-10-09', :store => 'BIE Store Jakarta', :total_price => 787232, :customer => nil)
items.insert(:date => '2022-06-18', :store => 'BIE Store Bandung', :total_price => 260135, :customer => 'Daffie Begwell')
items.insert(:date => '2022-10-12', :store => 'BIE Store Bandung', :total_price => 270581, :customer => 'Linn Rentoll')
items.insert(:date => '2022-07-06', :store => 'BIE Store Balikpapan', :total_price => 223795, :customer => 'Chloris Andries')
items.insert(:date => '2022-08-22', :store => 'BIE Store Balikpapan', :total_price => 852629, :customer => 'Isahella Tippler')
items.insert(:date => '2023-02-06', :store => 'BIE Store Balikpapan', :total_price => 439087, :customer => 'Zandra Terrell')
items.insert(:date => '2022-05-25', :store => 'BIE Store Malang', :total_price => 859131, :customer => 'Robert Skokoe')
items.insert(:date => '2023-03-08', :store => 'BIE Store Balikpapan', :total_price => 294759, :customer => 'Melina Oak')
items.insert(:date => '2022-07-15', :store => 'BIE Store Bandung', :total_price => 998789, :customer => 'Milty Guiel')
items.insert(:date => '2022-07-01', :store => 'BIE Store Balikpapan', :total_price => 740784, :customer => 'Wallas Waghorne')
items.insert(:date => '2023-01-28', :store => 'BIE Store Bandung', :total_price => 981498, :customer => 'Shalne Stoffersen')
items.insert(:date => '2022-04-14', :store => 'BIE Store Palembang', :total_price => 377813, :customer => 'Kiley Tappor')
items.insert(:date => '2022-11-19', :store => 'BIE Store Malang', :total_price => 759035, :customer => 'Benton Mockett')
items.insert(:date => '2022-03-23', :store => 'BIE Store Jakarta', :total_price => 103406, :customer => 'Caspar Jenicek')
items.insert(:date => '2022-11-07', :store => 'BIE Store Palembang', :total_price => 614260, :customer => 'Tamara Lewens')
items.insert(:date => '2022-11-11', :store => 'BIE Store Jakarta', :total_price => 298828, :customer => 'Perry Sampey')
items.insert(:date => '2022-11-02', :store => 'BIE Store Malang', :total_price => 541542, :customer => 'Nickolas Garrat')
items.insert(:date => '2022-05-27', :store => 'BIE Store Balikpapan', :total_price => 281571, :customer => 'Anthea Traut')
items.insert(:date => '2022-03-29', :store => 'BIE Store Malang', :total_price => 849457, :customer => 'Rosaleen Elland')
items.insert(:date => '2022-12-14', :store => 'BIE Store Malang', :total_price => 540715, :customer => 'Lorianna Vibert')
items.insert(:date => '2023-01-06', :store => 'BIE Store Balikpapan', :total_price => 60332, :customer => 'Morgana Vasilchikov')
items.insert(:date => '2022-11-13', :store => 'BIE Store Palembang', :total_price => 526603, :customer => 'Reinaldos Agett')
items.insert(:date => '2023-02-02', :store => 'BIE Store Jakarta', :total_price => 13141, :customer => nil)
items.insert(:date => '2022-05-10', :store => 'BIE Store Malang', :total_price => 973437, :customer => 'Slade Herries')
items.insert(:date => '2022-07-18', :store => 'BIE Store Bandung', :total_price => 65234, :customer => 'Stephanus Brouncker')
items.insert(:date => '2022-04-07', :store => 'BIE Store Jakarta', :total_price => 160778, :customer => 'Allissa McGraw')
items.insert(:date => '2023-01-04', :store => 'BIE Store Palembang', :total_price => 766479, :customer => 'Laughton Tooby')
items.insert(:date => '2023-01-24', :store => 'BIE Store Balikpapan', :total_price => 990204, :customer => 'Alexei Glennon')
items.insert(:date => '2022-09-30', :store => 'BIE Store Malang', :total_price => 604567, :customer => 'Carol Whitman')
items.insert(:date => '2022-11-10', :store => 'BIE Store Malang', :total_price => 227458, :customer => nil)
items.insert(:date => '2023-01-13', :store => 'BIE Store Malang', :total_price => 307873, :customer => 'Giordano Wikey')
items.insert(:date => '2023-03-14', :store => 'BIE Store Palembang', :total_price => 161949, :customer => 'Horten Harrell')
items.insert(:date => '2023-01-22', :store => 'BIE Store Jakarta', :total_price => 133532, :customer => 'Harbert O Mullen')
items.insert(:date => '2022-12-13', :store => 'BIE Store Jakarta', :total_price => 665895, :customer => 'Isak Grassot')
items.insert(:date => '2022-09-21', :store => 'BIE Store Jakarta', :total_price => 297254, :customer => 'Lorry Vuitton')
items.insert(:date => '2022-05-14', :store => 'BIE Store Palembang', :total_price => 965124, :customer => 'Cathee Pietzner')
items.insert(:date => '2022-10-15', :store => 'BIE Store Balikpapan', :total_price => 136679, :customer => 'Rutger Balderston')
items.insert(:date => '2022-05-29', :store => 'BIE Store Balikpapan', :total_price => 778746, :customer => 'Lillian Battill')
items.insert(:date => '2022-07-04', :store => 'BIE Store Bandung', :total_price => 469717, :customer => nil)
items.insert(:date => '2023-03-15', :store => 'BIE Store Bandung', :total_price => 175495, :customer => 'Ruby Hawkslee')
items.insert(:date => '2022-07-25', :store => 'BIE Store Balikpapan', :total_price => 479481, :customer => 'Selma Forbear')
items.insert(:date => '2022-11-14', :store => 'BIE Store Malang', :total_price => 490897, :customer => nil)
items.insert(:date => '2022-08-27', :store => 'BIE Store Malang', :total_price => 404408, :customer => 'Chiquita Yurenev')
items.insert(:date => '2022-06-02', :store => 'BIE Store Palembang', :total_price => 811480, :customer => 'Fayth Learie')
items.insert(:date => '2023-01-04', :store => 'BIE Store Bandung', :total_price => 171245, :customer => 'Ashby Houseley')
items.insert(:date => '2023-01-04', :store => 'BIE Store Balikpapan', :total_price => 761026, :customer => 'Marie Goodee')
items.insert(:date => '2022-12-27', :store => 'BIE Store Bandung', :total_price => 813168, :customer => 'Barrett Tolchar')
items.insert(:date => '2022-04-09', :store => 'BIE Store Palembang', :total_price => 262573, :customer => 'Tami Smidmoor')
items.insert(:date => '2022-05-27', :store => 'BIE Store Jakarta', :total_price => 413160, :customer => 'Darn Alennikov')
items.insert(:date => '2022-10-01', :store => 'BIE Store Jakarta', :total_price => 262314, :customer => 'Remington Stammer')
items.insert(:date => '2022-12-20', :store => 'BIE Store Bandung', :total_price => 998974, :customer => 'Marcos Haberjam')
items.insert(:date => '2022-05-26', :store => 'BIE Store Bandung', :total_price => 206664, :customer => 'Daryl McIndoe')
items.insert(:date => '2022-03-26', :store => 'BIE Store Palembang', :total_price => 513994, :customer => 'Doll Shropshire')
items.insert(:date => '2022-03-25', :store => 'BIE Store Balikpapan', :total_price => 507814, :customer => nil)
items.insert(:date => '2022-10-13', :store => 'BIE Store Bandung', :total_price => 100271, :customer => 'Brocky Pudan')
items.insert(:date => '2022-12-16', :store => 'BIE Store Malang', :total_price => 941274, :customer => 'Selina Brunton')
items.insert(:date => '2023-03-11', :store => 'BIE Store Palembang', :total_price => 681016, :customer => 'Dorree Aberdein')
items.insert(:date => '2022-12-11', :store => 'BIE Store Jakarta', :total_price => 121186, :customer => 'Regen Brierley')
items.insert(:date => '2022-11-06', :store => 'BIE Store Bandung', :total_price => 492466, :customer => 'Elianora Binton')
items.insert(:date => '2022-11-26', :store => 'BIE Store Palembang', :total_price => 625147, :customer => 'Wang Mibourne')
items.insert(:date => '2022-05-13', :store => 'BIE Store Palembang', :total_price => 603396, :customer => 'Killian Akehurst')
items.insert(:date => '2022-03-28', :store => 'BIE Store Jakarta', :total_price => 514384, :customer => 'Leta Sinnocke')
items.insert(:date => '2022-12-19', :store => 'BIE Store Palembang', :total_price => 925273, :customer => 'Jordain Labin')
items.insert(:date => '2022-07-22', :store => 'BIE Store Malang', :total_price => 920519, :customer => 'Vania Wyman')
items.insert(:date => '2023-03-01', :store => 'BIE Store Balikpapan', :total_price => 418826, :customer => 'Raye Ellerington')
items.insert(:date => '2022-09-25', :store => 'BIE Store Jakarta', :total_price => 568757, :customer => 'L;urette Casazza')
items.insert(:date => '2022-04-19', :store => 'BIE Store Malang', :total_price => 325586, :customer => 'Hermie Diggin')
items.insert(:date => '2022-04-09', :store => 'BIE Store Jakarta', :total_price => 893002, :customer => 'Cornall Eggar')
items.insert(:date => '2022-09-28', :store => 'BIE Store Balikpapan', :total_price => 681807, :customer => 'Stewart McPhail')
items.insert(:date => '2022-08-16', :store => 'BIE Store Jakarta', :total_price => 103808, :customer => 'Ilsa Allday')
items.insert(:date => '2022-05-06', :store => 'BIE Store Balikpapan', :total_price => 850712, :customer => 'Bobbi Oliphant')
items.insert(:date => '2022-10-20', :store => 'BIE Store Malang', :total_price => 733188, :customer => 'Alicia Balchen')
items.insert(:date => '2022-06-13', :store => 'BIE Store Palembang', :total_price => 326823, :customer => nil)
items.insert(:date => '2022-10-26', :store => 'BIE Store Malang', :total_price => 187993, :customer => 'Fan Youens')
items.insert(:date => '2023-03-09', :store => 'BIE Store Jakarta', :total_price => 600253, :customer => 'Pattin McGrowther')
items.insert(:date => '2022-10-03', :store => 'BIE Store Palembang', :total_price => 57693, :customer => 'Gaby Gumb')
items.insert(:date => '2022-07-23', :store => 'BIE Store Jakarta', :total_price => 828902, :customer => 'Bibbie Oger')



# calling run_sql will print the results and return them so that you can test data within them.
# if you want to test different sets of data, then its best to move this code into its own top level describe
# block. If you are only testing one set though, its better to set the results before you enter a describe block
# so that the results are presented at the top of the output.
results = run_sql

describe :test do
  it "Should return 90 items" do
    expect(results.count).to eq 90
 end
  it "should order total_price from largest to smallest" do
    prices = results.map {|row| row[:store]}
    expect(prices).to eq(prices.sort)
  end
  
end


# Other tips about using run_sql:
# The SQL/code section supports multiple statements, seperated of course by a ";".
# When multiple SELECT statements are issued:
#    run_sql will return an array of arrays, unless only one SELECT statement returned results
#    INSERT and UPDATE results will not be included in the list
#    SELECT statements that return no results will not be included in the list

Failed Tests

Basic Ordering 2 DESC (BIE)

Perusahaan bernama BIE memiliki tabel transactions yang memilik skema seperti dibawah ini

Column Name	Data Type
transaction_id	`serial`
date	`date`
store	`string`
total_price	`float`
customer	`string`

Buatlah query sql untuk mendapatkan semua data transaksi, urutkan dari total_price paling besar ke paling kecil

-- Code Here

# TODO: replace with your own tests (TDD), these are just how-to examples to get you started.

# Ruby/Rspec/Sequel Example:
# While the code section is pure SQL, for testing we use Ruby & Rspec.
# Sequel (https://github.com/jeremyevans/sequel) is used to setup the database and run queries.
# The connection is already made for you, use DB to access.

DB.create_table :transactions do
  primary_key :transaction_id
  Date :date
  String :store
  Float :total_price
  String :customer
end

items = DB[:transactions] # Create a dataset

# Populate the table
items.insert(:date => '2023-01-27', :store => 'BIE Store Palembang', :total_price => 964172, :customer => 'Ruthi Pepall')
items.insert(:date => '2023-01-06', :store => 'BIE Store Jakarta', :total_price => 419689, :customer => 'Horatius McPhate')
items.insert(:date => '2022-10-16', :store => 'BIE Store Bandung', :total_price => 664220, :customer => 'Romonda Gosker')
items.insert(:date => '2023-02-22', :store => 'BIE Store Malang', :total_price => 147934, :customer => 'Hinda Maldin')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 367084, :customer => 'Cybill Upstone')
items.insert(:date => '2022-09-01', :store => 'BIE Store Jakarta', :total_price => 522890, :customer => nil)
items.insert(:date => '2023-01-12', :store => 'BIE Store Palembang', :total_price => 290499, :customer => 'Leda Soeiro')
items.insert(:date => '2022-06-30', :store => 'BIE Store Malang', :total_price => 677804, :customer => nil)
items.insert(:date => '2022-11-06', :store => 'BIE Store Malang', :total_price => 458234, :customer => 'Zaria Sinnett')
items.insert(:date => '2023-02-11', :store => 'BIE Store Jakarta', :total_price => 181251, :customer => 'Worthy Morkham')
items.insert(:date => '2022-06-02', :store => 'BIE Store Balikpapan', :total_price => 631237, :customer => 'Sonnnie Fantin')
items.insert(:date => '2023-01-08', :store => 'BIE Store Bandung', :total_price => 716369, :customer => 'Georgianna Schuricke')
items.insert(:date => '2023-02-27', :store => 'BIE Store Bandung', :total_price => 252423, :customer => 'Rutherford Nursey')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 916700, :customer => 'Daffie Traut')
items.insert(:date => '2022-10-28', :store => 'BIE Store Bandung', :total_price => 921096, :customer => 'Charmine Cabera')
items.insert(:date => '2022-11-17', :store => 'BIE Store Malang', :total_price => 805858, :customer => 'Tuck Carabet')
items.insert(:date => '2022-07-18', :store => 'BIE Store Jakarta', :total_price => 778746, :customer => 'Ted Anney')
items.insert(:date => '2022-08-17', :store => 'BIE Store Jakarta', :total_price => 810906, :customer => 'Stephie Eglin')
items.insert(:date => '2022-10-06', :store => 'BIE Store Palembang', :total_price => 631197, :customer => 'Guglielmo Yellowley')
items.insert(:date => '2023-03-12', :store => 'BIE Store Malang', :total_price => 153729, :customer => 'Woodie Glowacha')
items.insert(:date => '2022-09-23', :store => 'BIE Store Malang', :total_price => 448198, :customer => 'Tressa Dellenbach')
items.insert(:date => '2022-07-02', :store => 'BIE Store Jakarta', :total_price => 626042, :customer => 'Otha McKerton')
items.insert(:date => '2022-10-09', :store => 'BIE Store Jakarta', :total_price => 787232, :customer => nil)
items.insert(:date => '2022-06-18', :store => 'BIE Store Bandung', :total_price => 260135, :customer => 'Daffie Begwell')
items.insert(:date => '2022-10-12', :store => 'BIE Store Bandung', :total_price => 270581, :customer => 'Linn Rentoll')
items.insert(:date => '2022-07-06', :store => 'BIE Store Balikpapan', :total_price => 223795, :customer => 'Chloris Andries')
items.insert(:date => '2022-08-22', :store => 'BIE Store Balikpapan', :total_price => 852629, :customer => 'Isahella Tippler')
items.insert(:date => '2023-02-06', :store => 'BIE Store Balikpapan', :total_price => 439087, :customer => 'Zandra Terrell')
items.insert(:date => '2022-05-25', :store => 'BIE Store Malang', :total_price => 859131, :customer => 'Robert Skokoe')
items.insert(:date => '2023-03-08', :store => 'BIE Store Balikpapan', :total_price => 294759, :customer => 'Melina Oak')
items.insert(:date => '2022-07-15', :store => 'BIE Store Bandung', :total_price => 998789, :customer => 'Milty Guiel')
items.insert(:date => '2022-07-01', :store => 'BIE Store Balikpapan', :total_price => 740784, :customer => 'Wallas Waghorne')
items.insert(:date => '2023-01-28', :store => 'BIE Store Bandung', :total_price => 981498, :customer => 'Shalne Stoffersen')
items.insert(:date => '2022-04-14', :store => 'BIE Store Palembang', :total_price => 377813, :customer => 'Kiley Tappor')
items.insert(:date => '2022-11-19', :store => 'BIE Store Malang', :total_price => 759035, :customer => 'Benton Mockett')
items.insert(:date => '2022-03-23', :store => 'BIE Store Jakarta', :total_price => 103406, :customer => 'Caspar Jenicek')
items.insert(:date => '2022-11-07', :store => 'BIE Store Palembang', :total_price => 614260, :customer => 'Tamara Lewens')
items.insert(:date => '2022-11-11', :store => 'BIE Store Jakarta', :total_price => 298828, :customer => 'Perry Sampey')
items.insert(:date => '2022-11-02', :store => 'BIE Store Malang', :total_price => 541542, :customer => 'Nickolas Garrat')
items.insert(:date => '2022-05-27', :store => 'BIE Store Balikpapan', :total_price => 281571, :customer => 'Anthea Traut')
items.insert(:date => '2022-03-29', :store => 'BIE Store Malang', :total_price => 849457, :customer => 'Rosaleen Elland')
items.insert(:date => '2022-12-14', :store => 'BIE Store Malang', :total_price => 540715, :customer => 'Lorianna Vibert')
items.insert(:date => '2023-01-06', :store => 'BIE Store Balikpapan', :total_price => 60332, :customer => 'Morgana Vasilchikov')
items.insert(:date => '2022-11-13', :store => 'BIE Store Palembang', :total_price => 526603, :customer => 'Reinaldos Agett')
items.insert(:date => '2023-02-02', :store => 'BIE Store Jakarta', :total_price => 13141, :customer => nil)
items.insert(:date => '2022-05-10', :store => 'BIE Store Malang', :total_price => 973437, :customer => 'Slade Herries')
items.insert(:date => '2022-07-18', :store => 'BIE Store Bandung', :total_price => 65234, :customer => 'Stephanus Brouncker')
items.insert(:date => '2022-04-07', :store => 'BIE Store Jakarta', :total_price => 160778, :customer => 'Allissa McGraw')
items.insert(:date => '2023-01-04', :store => 'BIE Store Palembang', :total_price => 766479, :customer => 'Laughton Tooby')
items.insert(:date => '2023-01-24', :store => 'BIE Store Balikpapan', :total_price => 990204, :customer => 'Alexei Glennon')
items.insert(:date => '2022-09-30', :store => 'BIE Store Malang', :total_price => 604567, :customer => 'Carol Whitman')
items.insert(:date => '2022-11-10', :store => 'BIE Store Malang', :total_price => 227458, :customer => nil)
items.insert(:date => '2023-01-13', :store => 'BIE Store Malang', :total_price => 307873, :customer => 'Giordano Wikey')
items.insert(:date => '2023-03-14', :store => 'BIE Store Palembang', :total_price => 161949, :customer => 'Horten Harrell')
items.insert(:date => '2023-01-22', :store => 'BIE Store Jakarta', :total_price => 133532, :customer => 'Harbert O Mullen')
items.insert(:date => '2022-12-13', :store => 'BIE Store Jakarta', :total_price => 665895, :customer => 'Isak Grassot')
items.insert(:date => '2022-09-21', :store => 'BIE Store Jakarta', :total_price => 297254, :customer => 'Lorry Vuitton')
items.insert(:date => '2022-05-14', :store => 'BIE Store Palembang', :total_price => 965124, :customer => 'Cathee Pietzner')
items.insert(:date => '2022-10-15', :store => 'BIE Store Balikpapan', :total_price => 136679, :customer => 'Rutger Balderston')
items.insert(:date => '2022-05-29', :store => 'BIE Store Balikpapan', :total_price => 778746, :customer => 'Lillian Battill')
items.insert(:date => '2022-07-04', :store => 'BIE Store Bandung', :total_price => 469717, :customer => nil)
items.insert(:date => '2023-03-15', :store => 'BIE Store Bandung', :total_price => 175495, :customer => 'Ruby Hawkslee')
items.insert(:date => '2022-07-25', :store => 'BIE Store Balikpapan', :total_price => 479481, :customer => 'Selma Forbear')
items.insert(:date => '2022-11-14', :store => 'BIE Store Malang', :total_price => 490897, :customer => nil)
items.insert(:date => '2022-08-27', :store => 'BIE Store Malang', :total_price => 404408, :customer => 'Chiquita Yurenev')
items.insert(:date => '2022-06-02', :store => 'BIE Store Palembang', :total_price => 811480, :customer => 'Fayth Learie')
items.insert(:date => '2023-01-04', :store => 'BIE Store Bandung', :total_price => 171245, :customer => 'Ashby Houseley')
items.insert(:date => '2023-01-04', :store => 'BIE Store Balikpapan', :total_price => 761026, :customer => 'Marie Goodee')
items.insert(:date => '2022-12-27', :store => 'BIE Store Bandung', :total_price => 813168, :customer => 'Barrett Tolchar')
items.insert(:date => '2022-04-09', :store => 'BIE Store Palembang', :total_price => 262573, :customer => 'Tami Smidmoor')
items.insert(:date => '2022-05-27', :store => 'BIE Store Jakarta', :total_price => 413160, :customer => 'Darn Alennikov')
items.insert(:date => '2022-10-01', :store => 'BIE Store Jakarta', :total_price => 262314, :customer => 'Remington Stammer')
items.insert(:date => '2022-12-20', :store => 'BIE Store Bandung', :total_price => 998974, :customer => 'Marcos Haberjam')
items.insert(:date => '2022-05-26', :store => 'BIE Store Bandung', :total_price => 206664, :customer => 'Daryl McIndoe')
items.insert(:date => '2022-03-26', :store => 'BIE Store Palembang', :total_price => 513994, :customer => 'Doll Shropshire')
items.insert(:date => '2022-03-25', :store => 'BIE Store Balikpapan', :total_price => 507814, :customer => nil)
items.insert(:date => '2022-10-13', :store => 'BIE Store Bandung', :total_price => 100271, :customer => 'Brocky Pudan')
items.insert(:date => '2022-12-16', :store => 'BIE Store Malang', :total_price => 941274, :customer => 'Selina Brunton')
items.insert(:date => '2023-03-11', :store => 'BIE Store Palembang', :total_price => 681016, :customer => 'Dorree Aberdein')
items.insert(:date => '2022-12-11', :store => 'BIE Store Jakarta', :total_price => 121186, :customer => 'Regen Brierley')
items.insert(:date => '2022-11-06', :store => 'BIE Store Bandung', :total_price => 492466, :customer => 'Elianora Binton')
items.insert(:date => '2022-11-26', :store => 'BIE Store Palembang', :total_price => 625147, :customer => 'Wang Mibourne')
items.insert(:date => '2022-05-13', :store => 'BIE Store Palembang', :total_price => 603396, :customer => 'Killian Akehurst')
items.insert(:date => '2022-03-28', :store => 'BIE Store Jakarta', :total_price => 514384, :customer => 'Leta Sinnocke')
items.insert(:date => '2022-12-19', :store => 'BIE Store Palembang', :total_price => 925273, :customer => 'Jordain Labin')
items.insert(:date => '2022-07-22', :store => 'BIE Store Malang', :total_price => 920519, :customer => 'Vania Wyman')
items.insert(:date => '2023-03-01', :store => 'BIE Store Balikpapan', :total_price => 418826, :customer => 'Raye Ellerington')
items.insert(:date => '2022-09-25', :store => 'BIE Store Jakarta', :total_price => 568757, :customer => 'L;urette Casazza')
items.insert(:date => '2022-04-19', :store => 'BIE Store Malang', :total_price => 325586, :customer => 'Hermie Diggin')
items.insert(:date => '2022-04-09', :store => 'BIE Store Jakarta', :total_price => 893002, :customer => 'Cornall Eggar')
items.insert(:date => '2022-09-28', :store => 'BIE Store Balikpapan', :total_price => 681807, :customer => 'Stewart McPhail')
items.insert(:date => '2022-08-16', :store => 'BIE Store Jakarta', :total_price => 103808, :customer => 'Ilsa Allday')
items.insert(:date => '2022-05-06', :store => 'BIE Store Balikpapan', :total_price => 850712, :customer => 'Bobbi Oliphant')
items.insert(:date => '2022-10-20', :store => 'BIE Store Malang', :total_price => 733188, :customer => 'Alicia Balchen')
items.insert(:date => '2022-06-13', :store => 'BIE Store Palembang', :total_price => 326823, :customer => nil)
items.insert(:date => '2022-10-26', :store => 'BIE Store Malang', :total_price => 187993, :customer => 'Fan Youens')
items.insert(:date => '2023-03-09', :store => 'BIE Store Jakarta', :total_price => 600253, :customer => 'Pattin McGrowther')
items.insert(:date => '2022-10-03', :store => 'BIE Store Palembang', :total_price => 57693, :customer => 'Gaby Gumb')
items.insert(:date => '2022-07-23', :store => 'BIE Store Jakarta', :total_price => 828902, :customer => 'Bibbie Oger')




# calling run_sql will print the results and return them so that you can test data within them.
# if you want to test different sets of data, then its best to move this code into its own top level describe
# block. If you are only testing one set though, its better to set the results before you enter a describe block
# so that the results are presented at the top of the output.
results = run_sql

describe :test do
  it "Should return 99 items" do
    expect(results.count).to eq 99
 end
  it "should order total_price from largest to smallest" do
    prices = results.map {|row| row[:total_price]}
    expect(prices).to eq(prices.sort.reverse)
  end
  
end


# Other tips about using run_sql:
# The SQL/code section supports multiple statements, seperated of course by a ";".
# When multiple SELECT statements are issued:
#    run_sql will return an array of arrays, unless only one SELECT statement returned results
#    INSERT and UPDATE results will not be included in the list
#    SELECT statements that return no results will not be included in the list

Failed Tests

Basic Ordering 1 ASC (BIE)

Perusahaan bernama BIE memiliki tabel transactions yang memilik skema seperti dibawah ini

Column Name	Data Type
transaction_id	`serial`
date	`date`
store	`string`
total_price	`float`
customer	`string`

Buatlah query sql untuk mendapatkan semua data transaksi, urutkan dari total_price paling kecil ke paling besar

-- Code Here

# TODO: replace with your own tests (TDD), these are just how-to examples to get you started.

# Ruby/Rspec/Sequel Example:
# While the code section is pure SQL, for testing we use Ruby & Rspec.
# Sequel (https://github.com/jeremyevans/sequel) is used to setup the database and run queries.
# The connection is already made for you, use DB to access.

DB.create_table :transactions do
  primary_key :transaction_id
  Date :date
  String :store
  Float :total_price
  String :customer
end

items = DB[:transactions] # Create a dataset

# Populate the table
items.insert(:date => '2023-01-27', :store => 'BIE Store Palembang', :total_price => 964172, :customer => 'Ruthi Pepall')
items.insert(:date => '2023-01-06', :store => 'BIE Store Jakarta', :total_price => 419689, :customer => 'Horatius McPhate')
items.insert(:date => '2022-10-16', :store => 'BIE Store Bandung', :total_price => 664220, :customer => 'Romonda Gosker')
items.insert(:date => '2023-02-22', :store => 'BIE Store Malang', :total_price => 147934, :customer => 'Hinda Maldin')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 367084, :customer => 'Cybill Upstone')
items.insert(:date => '2022-09-01', :store => 'BIE Store Jakarta', :total_price => 522890, :customer => nil)
items.insert(:date => '2023-01-12', :store => 'BIE Store Palembang', :total_price => 290499, :customer => 'Leda Soeiro')
items.insert(:date => '2022-06-30', :store => 'BIE Store Malang', :total_price => 677804, :customer => nil)
items.insert(:date => '2022-11-06', :store => 'BIE Store Malang', :total_price => 458234, :customer => 'Zaria Sinnett')
items.insert(:date => '2023-02-11', :store => 'BIE Store Jakarta', :total_price => 181251, :customer => 'Worthy Morkham')
items.insert(:date => '2022-06-02', :store => 'BIE Store Balikpapan', :total_price => 631237, :customer => 'Sonnnie Fantin')
items.insert(:date => '2023-01-08', :store => 'BIE Store Bandung', :total_price => 716369, :customer => 'Georgianna Schuricke')
items.insert(:date => '2023-02-27', :store => 'BIE Store Bandung', :total_price => 252423, :customer => 'Rutherford Nursey')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 916700, :customer => 'Daffie Traut')
items.insert(:date => '2022-10-28', :store => 'BIE Store Bandung', :total_price => 921096, :customer => 'Charmine Cabera')
items.insert(:date => '2022-11-17', :store => 'BIE Store Malang', :total_price => 805858, :customer => 'Tuck Carabet')
items.insert(:date => '2022-07-18', :store => 'BIE Store Jakarta', :total_price => 778746, :customer => 'Ted Anney')
items.insert(:date => '2022-08-17', :store => 'BIE Store Jakarta', :total_price => 810906, :customer => 'Stephie Eglin')
items.insert(:date => '2022-10-06', :store => 'BIE Store Palembang', :total_price => 631197, :customer => 'Guglielmo Yellowley')
items.insert(:date => '2023-03-12', :store => 'BIE Store Malang', :total_price => 153729, :customer => 'Woodie Glowacha')
items.insert(:date => '2022-09-23', :store => 'BIE Store Malang', :total_price => 448198, :customer => 'Tressa Dellenbach')
items.insert(:date => '2022-07-02', :store => 'BIE Store Jakarta', :total_price => 626042, :customer => 'Otha McKerton')
items.insert(:date => '2022-10-09', :store => 'BIE Store Jakarta', :total_price => 787232, :customer => nil)
items.insert(:date => '2022-06-18', :store => 'BIE Store Bandung', :total_price => 260135, :customer => 'Daffie Begwell')
items.insert(:date => '2022-10-12', :store => 'BIE Store Bandung', :total_price => 270581, :customer => 'Linn Rentoll')
items.insert(:date => '2022-07-06', :store => 'BIE Store Balikpapan', :total_price => 223795, :customer => 'Chloris Andries')
items.insert(:date => '2022-08-22', :store => 'BIE Store Balikpapan', :total_price => 852629, :customer => 'Isahella Tippler')
items.insert(:date => '2023-02-06', :store => 'BIE Store Balikpapan', :total_price => 439087, :customer => 'Zandra Terrell')
items.insert(:date => '2022-05-25', :store => 'BIE Store Malang', :total_price => 859131, :customer => 'Robert Skokoe')
items.insert(:date => '2023-03-08', :store => 'BIE Store Balikpapan', :total_price => 294759, :customer => 'Melina Oak')
items.insert(:date => '2022-07-15', :store => 'BIE Store Bandung', :total_price => 998789, :customer => 'Milty Guiel')
items.insert(:date => '2022-07-01', :store => 'BIE Store Balikpapan', :total_price => 740784, :customer => 'Wallas Waghorne')
items.insert(:date => '2023-01-28', :store => 'BIE Store Bandung', :total_price => 981498, :customer => 'Shalne Stoffersen')
items.insert(:date => '2022-04-14', :store => 'BIE Store Palembang', :total_price => 377813, :customer => 'Kiley Tappor')
items.insert(:date => '2022-11-19', :store => 'BIE Store Malang', :total_price => 759035, :customer => 'Benton Mockett')
items.insert(:date => '2022-03-23', :store => 'BIE Store Jakarta', :total_price => 103406, :customer => 'Caspar Jenicek')
items.insert(:date => '2022-11-07', :store => 'BIE Store Palembang', :total_price => 614260, :customer => 'Tamara Lewens')
items.insert(:date => '2022-11-11', :store => 'BIE Store Jakarta', :total_price => 298828, :customer => 'Perry Sampey')
items.insert(:date => '2022-11-02', :store => 'BIE Store Malang', :total_price => 541542, :customer => 'Nickolas Garrat')
items.insert(:date => '2022-05-27', :store => 'BIE Store Balikpapan', :total_price => 281571, :customer => 'Anthea Traut')
items.insert(:date => '2022-03-29', :store => 'BIE Store Malang', :total_price => 849457, :customer => 'Rosaleen Elland')
items.insert(:date => '2022-12-14', :store => 'BIE Store Malang', :total_price => 540715, :customer => 'Lorianna Vibert')
items.insert(:date => '2023-01-06', :store => 'BIE Store Balikpapan', :total_price => 60332, :customer => 'Morgana Vasilchikov')
items.insert(:date => '2022-11-13', :store => 'BIE Store Palembang', :total_price => 526603, :customer => 'Reinaldos Agett')
items.insert(:date => '2023-02-02', :store => 'BIE Store Jakarta', :total_price => 13141, :customer => nil)
items.insert(:date => '2022-05-10', :store => 'BIE Store Malang', :total_price => 973437, :customer => 'Slade Herries')
items.insert(:date => '2022-07-18', :store => 'BIE Store Bandung', :total_price => 65234, :customer => 'Stephanus Brouncker')
items.insert(:date => '2022-04-07', :store => 'BIE Store Jakarta', :total_price => 160778, :customer => 'Allissa McGraw')
items.insert(:date => '2023-01-04', :store => 'BIE Store Palembang', :total_price => 766479, :customer => 'Laughton Tooby')
items.insert(:date => '2023-01-24', :store => 'BIE Store Balikpapan', :total_price => 990204, :customer => 'Alexei Glennon')
items.insert(:date => '2022-09-30', :store => 'BIE Store Malang', :total_price => 604567, :customer => 'Carol Whitman')
items.insert(:date => '2022-11-10', :store => 'BIE Store Malang', :total_price => 227458, :customer => nil)
items.insert(:date => '2023-01-13', :store => 'BIE Store Malang', :total_price => 307873, :customer => 'Giordano Wikey')
items.insert(:date => '2023-03-14', :store => 'BIE Store Palembang', :total_price => 161949, :customer => 'Horten Harrell')
items.insert(:date => '2023-01-22', :store => 'BIE Store Jakarta', :total_price => 133532, :customer => 'Harbert O Mullen')
items.insert(:date => '2022-12-13', :store => 'BIE Store Jakarta', :total_price => 665895, :customer => 'Isak Grassot')
items.insert(:date => '2022-09-21', :store => 'BIE Store Jakarta', :total_price => 297254, :customer => 'Lorry Vuitton')
items.insert(:date => '2022-05-14', :store => 'BIE Store Palembang', :total_price => 965124, :customer => 'Cathee Pietzner')
items.insert(:date => '2022-10-15', :store => 'BIE Store Balikpapan', :total_price => 136679, :customer => 'Rutger Balderston')
items.insert(:date => '2022-05-29', :store => 'BIE Store Balikpapan', :total_price => 778746, :customer => 'Lillian Battill')
items.insert(:date => '2022-07-04', :store => 'BIE Store Bandung', :total_price => 469717, :customer => nil)
items.insert(:date => '2023-03-15', :store => 'BIE Store Bandung', :total_price => 175495, :customer => 'Ruby Hawkslee')
items.insert(:date => '2022-07-25', :store => 'BIE Store Balikpapan', :total_price => 479481, :customer => 'Selma Forbear')
items.insert(:date => '2022-11-14', :store => 'BIE Store Malang', :total_price => 490897, :customer => nil)
items.insert(:date => '2022-08-27', :store => 'BIE Store Malang', :total_price => 404408, :customer => 'Chiquita Yurenev')
items.insert(:date => '2022-06-02', :store => 'BIE Store Palembang', :total_price => 811480, :customer => 'Fayth Learie')
items.insert(:date => '2023-01-04', :store => 'BIE Store Bandung', :total_price => 171245, :customer => 'Ashby Houseley')
items.insert(:date => '2023-01-04', :store => 'BIE Store Balikpapan', :total_price => 761026, :customer => 'Marie Goodee')
items.insert(:date => '2022-12-27', :store => 'BIE Store Bandung', :total_price => 813168, :customer => 'Barrett Tolchar')
items.insert(:date => '2022-04-09', :store => 'BIE Store Palembang', :total_price => 262573, :customer => 'Tami Smidmoor')
items.insert(:date => '2022-05-27', :store => 'BIE Store Jakarta', :total_price => 413160, :customer => 'Darn Alennikov')
items.insert(:date => '2022-10-01', :store => 'BIE Store Jakarta', :total_price => 262314, :customer => 'Remington Stammer')
items.insert(:date => '2022-12-20', :store => 'BIE Store Bandung', :total_price => 998974, :customer => 'Marcos Haberjam')
items.insert(:date => '2022-05-26', :store => 'BIE Store Bandung', :total_price => 206664, :customer => 'Daryl McIndoe')
items.insert(:date => '2022-03-26', :store => 'BIE Store Palembang', :total_price => 513994, :customer => 'Doll Shropshire')
items.insert(:date => '2022-03-25', :store => 'BIE Store Balikpapan', :total_price => 507814, :customer => nil)
items.insert(:date => '2022-10-13', :store => 'BIE Store Bandung', :total_price => 100271, :customer => 'Brocky Pudan')
items.insert(:date => '2022-12-16', :store => 'BIE Store Malang', :total_price => 941274, :customer => 'Selina Brunton')
items.insert(:date => '2023-03-11', :store => 'BIE Store Palembang', :total_price => 681016, :customer => 'Dorree Aberdein')
items.insert(:date => '2022-12-11', :store => 'BIE Store Jakarta', :total_price => 121186, :customer => 'Regen Brierley')
items.insert(:date => '2022-11-06', :store => 'BIE Store Bandung', :total_price => 492466, :customer => 'Elianora Binton')
items.insert(:date => '2022-11-26', :store => 'BIE Store Palembang', :total_price => 625147, :customer => 'Wang Mibourne')
items.insert(:date => '2022-05-13', :store => 'BIE Store Palembang', :total_price => 603396, :customer => 'Killian Akehurst')
items.insert(:date => '2022-03-28', :store => 'BIE Store Jakarta', :total_price => 514384, :customer => 'Leta Sinnocke')
items.insert(:date => '2022-12-19', :store => 'BIE Store Palembang', :total_price => 925273, :customer => 'Jordain Labin')
items.insert(:date => '2022-07-22', :store => 'BIE Store Malang', :total_price => 920519, :customer => 'Vania Wyman')
items.insert(:date => '2023-03-01', :store => 'BIE Store Balikpapan', :total_price => 418826, :customer => 'Raye Ellerington')
items.insert(:date => '2022-09-25', :store => 'BIE Store Jakarta', :total_price => 568757, :customer => 'L;urette Casazza')
items.insert(:date => '2022-04-19', :store => 'BIE Store Malang', :total_price => 325586, :customer => 'Hermie Diggin')
items.insert(:date => '2022-04-09', :store => 'BIE Store Jakarta', :total_price => 893002, :customer => 'Cornall Eggar')
items.insert(:date => '2022-09-28', :store => 'BIE Store Balikpapan', :total_price => 681807, :customer => 'Stewart McPhail')
items.insert(:date => '2022-08-16', :store => 'BIE Store Jakarta', :total_price => 103808, :customer => 'Ilsa Allday')
items.insert(:date => '2022-05-06', :store => 'BIE Store Balikpapan', :total_price => 850712, :customer => 'Bobbi Oliphant')
items.insert(:date => '2022-10-20', :store => 'BIE Store Malang', :total_price => 733188, :customer => 'Alicia Balchen')
items.insert(:date => '2022-06-13', :store => 'BIE Store Palembang', :total_price => 326823, :customer => nil)
items.insert(:date => '2022-10-26', :store => 'BIE Store Malang', :total_price => 187993, :customer => 'Fan Youens')
items.insert(:date => '2023-03-09', :store => 'BIE Store Jakarta', :total_price => 600253, :customer => 'Pattin McGrowther')
items.insert(:date => '2022-10-03', :store => 'BIE Store Palembang', :total_price => 57693, :customer => 'Gaby Gumb')
items.insert(:date => '2022-07-23', :store => 'BIE Store Jakarta', :total_price => 828902, :customer => 'Bibbie Oger')




# calling run_sql will print the results and return them so that you can test data within them.
# if you want to test different sets of data, then its best to move this code into its own top level describe
# block. If you are only testing one set though, its better to set the results before you enter a describe block
# so that the results are presented at the top of the output.
results = run_sql

describe :test do
  it "Should return 99 items" do
    expect(results.count).to eq 99
 end
  it "should order total_price from smallest to largest" do
    prices = results.map {|row| row[:total_price]}
    expect(prices).to eq(prices.sort)
  end
  
end


# Other tips about using run_sql:
# The SQL/code section supports multiple statements, seperated of course by a ";".
# When multiple SELECT statements are issued:
#    run_sql will return an array of arrays, unless only one SELECT statement returned results
#    INSERT and UPDATE results will not be included in the list
#    SELECT statements that return no results will not be included in the list

Failed Tests

Basic Filtering 9 OR (BIE)

Perusahaan bernama BIE memiliki tabel transactions yang memilik skema seperti dibawah ini

Column Name	Data Type
transaction_id	`serial`
date	`date`
store	`string`
total_price	`float`
customer	`string`

Buatlah query sql untuk mendapatkan semua data transaksi yang huruf awal customer nya D atau E

-- Code Here

# TODO: replace with your own tests (TDD), these are just how-to examples to get you started.

# Ruby/Rspec/Sequel Example:
# While the code section is pure SQL, for testing we use Ruby & Rspec.
# Sequel (https://github.com/jeremyevans/sequel) is used to setup the database and run queries.
# The connection is already made for you, use DB to access.

DB.create_table :transactions do
  primary_key :transaction_id
  Date :date
  String :store
  Float :total_price
  String :customer
end

items = DB[:transactions] # Create a dataset

# Populate the table
items.insert(:date => '2023-01-27', :store => 'BIE Store Palembang', :total_price => 964172, :customer => 'Ruthi Pepall')
items.insert(:date => '2023-01-06', :store => 'BIE Store Jakarta', :total_price => 419689, :customer => 'Horatius McPhate')
items.insert(:date => '2022-10-16', :store => 'BIE Store Bandung', :total_price => 664220, :customer => 'Romonda Gosker')
items.insert(:date => '2023-02-22', :store => 'BIE Store Malang', :total_price => 147934, :customer => 'Hinda Maldin')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 367084, :customer => 'Cybill Upstone')
items.insert(:date => '2022-09-01', :store => 'BIE Store Jakarta', :total_price => 522890, :customer => nil)
items.insert(:date => '2023-01-12', :store => 'BIE Store Palembang', :total_price => 290499, :customer => 'Leda Soeiro')
items.insert(:date => '2022-06-30', :store => 'BIE Store Malang', :total_price => 677804, :customer => nil)
items.insert(:date => '2022-11-06', :store => 'BIE Store Malang', :total_price => 458234, :customer => 'Zaria Sinnett')
items.insert(:date => '2023-02-11', :store => 'BIE Store Jakarta', :total_price => 181251, :customer => 'Worthy Morkham')
items.insert(:date => '2022-06-02', :store => 'BIE Store Balikpapan', :total_price => 631237, :customer => 'Sonnnie Fantin')
items.insert(:date => '2023-01-08', :store => 'BIE Store Bandung', :total_price => 716369, :customer => 'Georgianna Schuricke')
items.insert(:date => '2023-02-27', :store => 'BIE Store Bandung', :total_price => 252423, :customer => 'Rutherford Nursey')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 916700, :customer => 'Daffie Traut')
items.insert(:date => '2022-10-28', :store => 'BIE Store Bandung', :total_price => 921096, :customer => 'Charmine Cabera')
items.insert(:date => '2022-11-17', :store => 'BIE Store Malang', :total_price => 805858, :customer => 'Tuck Carabet')
items.insert(:date => '2022-07-18', :store => 'BIE Store Jakarta', :total_price => 778746, :customer => 'Ted Anney')
items.insert(:date => '2022-08-17', :store => 'BIE Store Jakarta', :total_price => 810906, :customer => 'Stephie Eglin')
items.insert(:date => '2022-10-06', :store => 'BIE Store Palembang', :total_price => 631197, :customer => 'Guglielmo Yellowley')
items.insert(:date => '2023-03-12', :store => 'BIE Store Malang', :total_price => 153729, :customer => 'Woodie Glowacha')
items.insert(:date => '2022-09-23', :store => 'BIE Store Malang', :total_price => 448198, :customer => 'Tressa Dellenbach')
items.insert(:date => '2022-07-02', :store => 'BIE Store Jakarta', :total_price => 626042, :customer => 'Otha McKerton')
items.insert(:date => '2022-10-09', :store => 'BIE Store Jakarta', :total_price => 787232, :customer => nil)
items.insert(:date => '2022-06-18', :store => 'BIE Store Bandung', :total_price => 260135, :customer => 'Daffie Begwell')
items.insert(:date => '2022-10-12', :store => 'BIE Store Bandung', :total_price => 270581, :customer => 'Linn Rentoll')
items.insert(:date => '2022-07-06', :store => 'BIE Store Balikpapan', :total_price => 223795, :customer => 'Chloris Andries')
items.insert(:date => '2022-08-22', :store => 'BIE Store Balikpapan', :total_price => 852629, :customer => 'Isahella Tippler')
items.insert(:date => '2023-02-06', :store => 'BIE Store Balikpapan', :total_price => 439087, :customer => 'Zandra Terrell')
items.insert(:date => '2022-05-25', :store => 'BIE Store Malang', :total_price => 859131, :customer => 'Robert Skokoe')
items.insert(:date => '2023-03-08', :store => 'BIE Store Balikpapan', :total_price => 294759, :customer => 'Melina Oak')
items.insert(:date => '2022-07-15', :store => 'BIE Store Bandung', :total_price => 998789, :customer => 'Milty Guiel')
items.insert(:date => '2022-07-01', :store => 'BIE Store Balikpapan', :total_price => 740784, :customer => 'Wallas Waghorne')
items.insert(:date => '2023-01-28', :store => 'BIE Store Bandung', :total_price => 981498, :customer => 'Shalne Stoffersen')
items.insert(:date => '2022-04-14', :store => 'BIE Store Palembang', :total_price => 377813, :customer => 'Kiley Tappor')
items.insert(:date => '2022-11-19', :store => 'BIE Store Malang', :total_price => 759035, :customer => 'Benton Mockett')
items.insert(:date => '2022-03-23', :store => 'BIE Store Jakarta', :total_price => 103406, :customer => 'Caspar Jenicek')
items.insert(:date => '2022-11-07', :store => 'BIE Store Palembang', :total_price => 614260, :customer => 'Tamara Lewens')
items.insert(:date => '2022-11-11', :store => 'BIE Store Jakarta', :total_price => 298828, :customer => 'Perry Sampey')
items.insert(:date => '2022-11-02', :store => 'BIE Store Malang', :total_price => 541542, :customer => 'Nickolas Garrat')
items.insert(:date => '2022-05-27', :store => 'BIE Store Balikpapan', :total_price => 281571, :customer => 'Anthea Traut')
items.insert(:date => '2022-03-29', :store => 'BIE Store Malang', :total_price => 849457, :customer => 'Rosaleen Elland')
items.insert(:date => '2022-12-14', :store => 'BIE Store Malang', :total_price => 540715, :customer => 'Lorianna Vibert')
items.insert(:date => '2023-01-06', :store => 'BIE Store Balikpapan', :total_price => 60332, :customer => 'Morgana Vasilchikov')
items.insert(:date => '2022-11-13', :store => 'BIE Store Palembang', :total_price => 526603, :customer => 'Reinaldos Agett')
items.insert(:date => '2023-02-02', :store => 'BIE Store Jakarta', :total_price => 13141, :customer => nil)
items.insert(:date => '2022-05-10', :store => 'BIE Store Malang', :total_price => 973437, :customer => 'Slade Herries')
items.insert(:date => '2022-07-18', :store => 'BIE Store Bandung', :total_price => 65234, :customer => 'Stephanus Brouncker')
items.insert(:date => '2022-04-07', :store => 'BIE Store Jakarta', :total_price => 160778, :customer => 'Allissa McGraw')
items.insert(:date => '2023-01-04', :store => 'BIE Store Palembang', :total_price => 766479, :customer => 'Laughton Tooby')
items.insert(:date => '2023-01-24', :store => 'BIE Store Balikpapan', :total_price => 990204, :customer => 'Alexei Glennon')
items.insert(:date => '2022-09-30', :store => 'BIE Store Malang', :total_price => 604567, :customer => 'Carol Whitman')
items.insert(:date => '2022-11-10', :store => 'BIE Store Malang', :total_price => 227458, :customer => nil)
items.insert(:date => '2023-01-13', :store => 'BIE Store Malang', :total_price => 307873, :customer => 'Giordano Wikey')
items.insert(:date => '2023-03-14', :store => 'BIE Store Palembang', :total_price => 161949, :customer => 'Horten Harrell')
items.insert(:date => '2023-01-22', :store => 'BIE Store Jakarta', :total_price => 133532, :customer => 'Harbert O Mullen')
items.insert(:date => '2022-12-13', :store => 'BIE Store Jakarta', :total_price => 665895, :customer => 'Isak Grassot')
items.insert(:date => '2022-09-21', :store => 'BIE Store Jakarta', :total_price => 297254, :customer => 'Lorry Vuitton')
items.insert(:date => '2022-05-14', :store => 'BIE Store Palembang', :total_price => 965124, :customer => 'Cathee Pietzner')
items.insert(:date => '2022-10-15', :store => 'BIE Store Balikpapan', :total_price => 136679, :customer => 'Rutger Balderston')
items.insert(:date => '2022-05-29', :store => 'BIE Store Balikpapan', :total_price => 778746, :customer => 'Lillian Battill')
items.insert(:date => '2022-07-04', :store => 'BIE Store Bandung', :total_price => 469717, :customer => nil)
items.insert(:date => '2023-03-15', :store => 'BIE Store Bandung', :total_price => 175495, :customer => 'Ruby Hawkslee')
items.insert(:date => '2022-07-25', :store => 'BIE Store Balikpapan', :total_price => 479481, :customer => 'Selma Forbear')
items.insert(:date => '2022-11-14', :store => 'BIE Store Malang', :total_price => 490897, :customer => nil)
items.insert(:date => '2022-08-27', :store => 'BIE Store Malang', :total_price => 404408, :customer => 'Chiquita Yurenev')
items.insert(:date => '2022-06-02', :store => 'BIE Store Palembang', :total_price => 811480, :customer => 'Fayth Learie')
items.insert(:date => '2023-01-04', :store => 'BIE Store Bandung', :total_price => 171245, :customer => 'Ashby Houseley')
items.insert(:date => '2023-01-04', :store => 'BIE Store Balikpapan', :total_price => 761026, :customer => 'Marie Goodee')
items.insert(:date => '2022-12-27', :store => 'BIE Store Bandung', :total_price => 813168, :customer => 'Barrett Tolchar')
items.insert(:date => '2022-04-09', :store => 'BIE Store Palembang', :total_price => 262573, :customer => 'Tami Smidmoor')
items.insert(:date => '2022-05-27', :store => 'BIE Store Jakarta', :total_price => 413160, :customer => 'Darn Alennikov')
items.insert(:date => '2022-10-01', :store => 'BIE Store Jakarta', :total_price => 262314, :customer => 'Remington Stammer')
items.insert(:date => '2022-12-20', :store => 'BIE Store Bandung', :total_price => 998974, :customer => 'Marcos Haberjam')
items.insert(:date => '2022-05-26', :store => 'BIE Store Bandung', :total_price => 206664, :customer => 'Daryl McIndoe')
items.insert(:date => '2022-03-26', :store => 'BIE Store Palembang', :total_price => 513994, :customer => 'Doll Shropshire')
items.insert(:date => '2022-03-25', :store => 'BIE Store Balikpapan', :total_price => 507814, :customer => nil)
items.insert(:date => '2022-10-13', :store => 'BIE Store Bandung', :total_price => 100271, :customer => 'Brocky Pudan')
items.insert(:date => '2022-12-16', :store => 'BIE Store Malang', :total_price => 941274, :customer => 'Selina Brunton')
items.insert(:date => '2023-03-11', :store => 'BIE Store Palembang', :total_price => 681016, :customer => 'Dorree Aberdein')
items.insert(:date => '2022-12-11', :store => 'BIE Store Jakarta', :total_price => 121186, :customer => 'Regen Brierley')
items.insert(:date => '2022-11-06', :store => 'BIE Store Bandung', :total_price => 492466, :customer => 'Elianora Binton')
items.insert(:date => '2022-11-26', :store => 'BIE Store Palembang', :total_price => 625147, :customer => 'Wang Mibourne')
items.insert(:date => '2022-05-13', :store => 'BIE Store Palembang', :total_price => 603396, :customer => 'Killian Akehurst')
items.insert(:date => '2022-03-28', :store => 'BIE Store Jakarta', :total_price => 514384, :customer => 'Leta Sinnocke')
items.insert(:date => '2022-12-19', :store => 'BIE Store Palembang', :total_price => 925273, :customer => 'Jordain Labin')
items.insert(:date => '2022-07-22', :store => 'BIE Store Malang', :total_price => 920519, :customer => 'Vania Wyman')
items.insert(:date => '2023-03-01', :store => 'BIE Store Balikpapan', :total_price => 418826, :customer => 'Raye Ellerington')
items.insert(:date => '2022-09-25', :store => 'BIE Store Jakarta', :total_price => 568757, :customer => 'L;urette Casazza')
items.insert(:date => '2022-04-19', :store => 'BIE Store Malang', :total_price => 325586, :customer => 'Hermie Diggin')
items.insert(:date => '2022-04-09', :store => 'BIE Store Jakarta', :total_price => 893002, :customer => 'Cornall Eggar')
items.insert(:date => '2022-09-28', :store => 'BIE Store Balikpapan', :total_price => 681807, :customer => 'Stewart McPhail')
items.insert(:date => '2022-08-16', :store => 'BIE Store Jakarta', :total_price => 103808, :customer => 'Ilsa Allday')
items.insert(:date => '2022-05-06', :store => 'BIE Store Balikpapan', :total_price => 850712, :customer => 'Bobbi Oliphant')
items.insert(:date => '2022-10-20', :store => 'BIE Store Malang', :total_price => 733188, :customer => 'Alicia Balchen')
items.insert(:date => '2022-06-13', :store => 'BIE Store Palembang', :total_price => 326823, :customer => nil)
items.insert(:date => '2022-10-26', :store => 'BIE Store Malang', :total_price => 187993, :customer => 'Fan Youens')
items.insert(:date => '2023-03-09', :store => 'BIE Store Jakarta', :total_price => 600253, :customer => 'Pattin McGrowther')
items.insert(:date => '2022-10-03', :store => 'BIE Store Palembang', :total_price => 57693, :customer => 'Gaby Gumb')
items.insert(:date => '2022-07-23', :store => 'BIE Store Jakarta', :total_price => 828902, :customer => 'Bibbie Oger')




# calling run_sql will print the results and return them so that you can test data within them.
# if you want to test different sets of data, then its best to move this code into its own top level describe
# block. If you are only testing one set though, its better to set the results before you enter a describe block
# so that the results are presented at the top of the output.
results = run_sql

describe :test do
  it "First letter of customer should be either D or E" do
    results.each do |row|
      expect(row[:customer][0] == 'D' || row[:customer][0] == 'E').to be true
    end
  end
  
end


# Other tips about using run_sql:
# The SQL/code section supports multiple statements, seperated of course by a ";".
# When multiple SELECT statements are issued:
#    run_sql will return an array of arrays, unless only one SELECT statement returned results
#    INSERT and UPDATE results will not be included in the list
#    SELECT statements that return no results will not be included in the list

Failed Tests

Basic Filtering 8 Is Not (BIE)

Perusahaan bernama BIE memiliki tabel transactions yang memilik skema seperti dibawah ini

Column Name	Data Type
transaction_id	`serial`
date	`date`
store	`string`
total_price	`float`
customer	`string`

Buatlah query sql untuk mendapatkan semua data transaksi yang customer nya null

-- Code Here

# TODO: replace with your own tests (TDD), these are just how-to examples to get you started.

# Ruby/Rspec/Sequel Example:
# While the code section is pure SQL, for testing we use Ruby & Rspec.
# Sequel (https://github.com/jeremyevans/sequel) is used to setup the database and run queries.
# The connection is already made for you, use DB to access.

DB.create_table :transactions do
  primary_key :transaction_id
  Date :date
  String :store
  Float :total_price
  String :customer
end

items = DB[:transactions] # Create a dataset

# Populate the table
items.insert(:date => '2023-01-27', :store => 'BIE Store Palembang', :total_price => 964172, :customer => 'Ruthi Pepall')
items.insert(:date => '2023-01-06', :store => 'BIE Store Jakarta', :total_price => 419689, :customer => 'Horatius McPhate')
items.insert(:date => '2022-10-16', :store => 'BIE Store Bandung', :total_price => 664220, :customer => 'Romonda Gosker')
items.insert(:date => '2023-02-22', :store => 'BIE Store Malang', :total_price => 147934, :customer => 'Hinda Maldin')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 367084, :customer => 'Cybill Upstone')
items.insert(:date => '2022-09-01', :store => 'BIE Store Jakarta', :total_price => 522890, :customer => nil)
items.insert(:date => '2023-01-12', :store => 'BIE Store Palembang', :total_price => 290499, :customer => 'Leda Soeiro')
items.insert(:date => '2022-06-30', :store => 'BIE Store Malang', :total_price => 677804, :customer => nil)
items.insert(:date => '2022-11-06', :store => 'BIE Store Malang', :total_price => 458234, :customer => 'Zaria Sinnett')
items.insert(:date => '2023-02-11', :store => 'BIE Store Jakarta', :total_price => 181251, :customer => 'Worthy Morkham')
items.insert(:date => '2022-06-02', :store => 'BIE Store Balikpapan', :total_price => 631237, :customer => 'Sonnnie Fantin')
items.insert(:date => '2023-01-08', :store => 'BIE Store Bandung', :total_price => 716369, :customer => 'Georgianna Schuricke')
items.insert(:date => '2023-02-27', :store => 'BIE Store Bandung', :total_price => 252423, :customer => 'Rutherford Nursey')
items.insert(:date => '2022-11-29', :store => 'BIE Store Balikpapan', :total_price => 916700, :customer => 'Daffie Traut')
items.insert(:date => '2022-10-28', :store => 'BIE Store Bandung', :total_price => 921096, :customer => 'Charmine Cabera')
items.insert(:date => '2022-11-17', :store => 'BIE Store Malang', :total_price => 805858, :customer => 'Tuck Carabet')
items.insert(:date => '2022-07-18', :store => 'BIE Store Jakarta', :total_price => 778746, :customer => 'Ted Anney')
items.insert(:date => '2022-08-17', :store => 'BIE Store Jakarta', :total_price => 810906, :customer => 'Stephie Eglin')
items.insert(:date => '2022-10-06', :store => 'BIE Store Palembang', :total_price => 631197, :customer => 'Guglielmo Yellowley')
items.insert(:date => '2023-03-12', :store => 'BIE Store Malang', :total_price => 153729, :customer => 'Woodie Glowacha')
items.insert(:date => '2022-09-23', :store => 'BIE Store Malang', :total_price => 448198, :customer => 'Tressa Dellenbach')
items.insert(:date => '2022-07-02', :store => 'BIE Store Jakarta', :total_price => 626042, :customer => 'Otha McKerton')
items.insert(:date => '2022-10-09', :store => 'BIE Store Jakarta', :total_price => 787232, :customer => nil)
items.insert(:date => '2022-06-18', :store => 'BIE Store Bandung', :total_price => 260135, :customer => 'Daffie Begwell')
items.insert(:date => '2022-10-12', :store => 'BIE Store Bandung', :total_price => 270581, :customer => 'Linn Rentoll')
items.insert(:date => '2022-07-06', :store => 'BIE Store Balikpapan', :total_price => 223795, :customer => 'Chloris Andries')
items.insert(:date => '2022-08-22', :store => 'BIE Store Balikpapan', :total_price => 852629, :customer => 'Isahella Tippler')
items.insert(:date => '2023-02-06', :store => 'BIE Store Balikpapan', :total_price => 439087, :customer => 'Zandra Terrell')
items.insert(:date => '2022-05-25', :store => 'BIE Store Malang', :total_price => 859131, :customer => 'Robert Skokoe')
items.insert(:date => '2023-03-08', :store => 'BIE Store Balikpapan', :total_price => 294759, :customer => 'Melina Oak')
items.insert(:date => '2022-07-15', :store => 'BIE Store Bandung', :total_price => 998789, :customer => 'Milty Guiel')
items.insert(:date => '2022-07-01', :store => 'BIE Store Balikpapan', :total_price => 740784, :customer => 'Wallas Waghorne')
items.insert(:date => '2023-01-28', :store => 'BIE Store Bandung', :total_price => 981498, :customer => 'Shalne Stoffersen')
items.insert(:date => '2022-04-14', :store => 'BIE Store Palembang', :total_price => 377813, :customer => 'Kiley Tappor')
items.insert(:date => '2022-11-19', :store => 'BIE Store Malang', :total_price => 759035, :customer => 'Benton Mockett')
items.insert(:date => '2022-03-23', :store => 'BIE Store Jakarta', :total_price => 103406, :customer => 'Caspar Jenicek')
items.insert(:date => '2022-11-07', :store => 'BIE Store Palembang', :total_price => 614260, :customer => 'Tamara Lewens')
items.insert(:date => '2022-11-11', :store => 'BIE Store Jakarta', :total_price => 298828, :customer => 'Perry Sampey')
items.insert(:date => '2022-11-02', :store => 'BIE Store Malang', :total_price => 541542, :customer => 'Nickolas Garrat')
items.insert(:date => '2022-05-27', :store => 'BIE Store Balikpapan', :total_price => 281571, :customer => 'Anthea Traut')
items.insert(:date => '2022-03-29', :store => 'BIE Store Malang', :total_price => 849457, :customer => 'Rosaleen Elland')
items.insert(:date => '2022-12-14', :store => 'BIE Store Malang', :total_price => 540715, :customer => 'Lorianna Vibert')
items.insert(:date => '2023-01-06', :store => 'BIE Store Balikpapan', :total_price => 60332, :customer => 'Morgana Vasilchikov')
items.insert(:date => '2022-11-13', :store => 'BIE Store Palembang', :total_price => 526603, :customer => 'Reinaldos Agett')
items.insert(:date => '2023-02-02', :store => 'BIE Store Jakarta', :total_price => 13141, :customer => nil)
items.insert(:date => '2022-05-10', :store => 'BIE Store Malang', :total_price => 973437, :customer => 'Slade Herries')
items.insert(:date => '2022-07-18', :store => 'BIE Store Bandung', :total_price => 65234, :customer => 'Stephanus Brouncker')
items.insert(:date => '2022-04-07', :store => 'BIE Store Jakarta', :total_price => 160778, :customer => 'Allissa McGraw')
items.insert(:date => '2023-01-04', :store => 'BIE Store Palembang', :total_price => 766479, :customer => 'Laughton Tooby')
items.insert(:date => '2023-01-24', :store => 'BIE Store Balikpapan', :total_price => 990204, :customer => 'Alexei Glennon')
items.insert(:date => '2022-09-30', :store => 'BIE Store Malang', :total_price => 604567, :customer => 'Carol Whitman')
items.insert(:date => '2022-11-10', :store => 'BIE Store Malang', :total_price => 227458, :customer => nil)
items.insert(:date => '2023-01-13', :store => 'BIE Store Malang', :total_price => 307873, :customer => 'Giordano Wikey')
items.insert(:date => '2023-03-14', :store => 'BIE Store Palembang', :total_price => 161949, :customer => 'Horten Harrell')
items.insert(:date => '2023-01-22', :store => 'BIE Store Jakarta', :total_price => 133532, :customer => 'Harbert O Mullen')
items.insert(:date => '2022-12-13', :store => 'BIE Store Jakarta', :total_price => 665895, :customer => 'Isak Grassot')
items.insert(:date => '2022-09-21', :store => 'BIE Store Jakarta', :total_price => 297254, :customer => 'Lorry Vuitton')
items.insert(:date => '2022-05-14', :store => 'BIE Store Palembang', :total_price => 965124, :customer => 'Cathee Pietzner')
items.insert(:date => '2022-10-15', :store => 'BIE Store Balikpapan', :total_price => 136679, :customer => 'Rutger Balderston')
items.insert(:date => '2022-05-29', :store => 'BIE Store Balikpapan', :total_price => 778746, :customer => 'Lillian Battill')
items.insert(:date => '2022-07-04', :store => 'BIE Store Bandung', :total_price => 469717, :customer => nil)
items.insert(:date => '2023-03-15', :store => 'BIE Store Bandung', :total_price => 175495, :customer => 'Ruby Hawkslee')
items.insert(:date => '2022-07-25', :store => 'BIE Store Balikpapan', :total_price => 479481, :customer => 'Selma Forbear')
items.insert(:date => '2022-11-14', :store => 'BIE Store Malang', :total_price => 490897, :customer => nil)
items.insert(:date => '2022-08-27', :store => 'BIE Store Malang', :total_price => 404408, :customer => 'Chiquita Yurenev')
items.insert(:date => '2022-06-02', :store => 'BIE Store Palembang', :total_price => 811480, :customer => 'Fayth Learie')
items.insert(:date => '2023-01-04', :store => 'BIE Store Bandung', :total_price => 171245, :customer => 'Ashby Houseley')
items.insert(:date => '2023-01-04', :store => 'BIE Store Balikpapan', :total_price => 761026, :customer => 'Marie Goodee')
items.insert(:date => '2022-12-27', :store => 'BIE Store Bandung', :total_price => 813168, :customer => 'Barrett Tolchar')
items.insert(:date => '2022-04-09', :store => 'BIE Store Palembang', :total_price => 262573, :customer => 'Tami Smidmoor')
items.insert(:date => '2022-05-27', :store => 'BIE Store Jakarta', :total_price => 413160, :customer => 'Darn Alennikov')
items.insert(:date => '2022-10-01', :store => 'BIE Store Jakarta', :total_price => 262314, :customer => 'Remington Stammer')
items.insert(:date => '2022-12-20', :store => 'BIE Store Bandung', :total_price => 998974, :customer => 'Marcos Haberjam')
items.insert(:date => '2022-05-26', :store => 'BIE Store Bandung', :total_price => 206664, :customer => 'Daryl McIndoe')
items.insert(:date => '2022-03-26', :store => 'BIE Store Palembang', :total_price => 513994, :customer => 'Doll Shropshire')
items.insert(:date => '2022-03-25', :store => 'BIE Store Balikpapan', :total_price => 507814, :customer => nil)
items.insert(:date => '2022-10-13', :store => 'BIE Store Bandung', :total_price => 100271, :customer => 'Brocky Pudan')
items.insert(:date => '2022-12-16', :store => 'BIE Store Malang', :total_price => 941274, :customer => 'Selina Brunton')
items.insert(:date => '2023-03-11', :store => 'BIE Store Palembang', :total_price => 681016, :customer => 'Dorree Aberdein')
items.insert(:date => '2022-12-11', :store => 'BIE Store Jakarta', :total_price => 121186, :customer => 'Regen Brierley')
items.insert(:date => '2022-11-06', :store => 'BIE Store Bandung', :total_price => 492466, :customer => 'Elianora Binton')
items.insert(:date => '2022-11-26', :store => 'BIE Store Palembang', :total_price => 625147, :customer => 'Wang Mibourne')
items.insert(:date => '2022-05-13', :store => 'BIE Store Palembang', :total_price => 603396, :customer => 'Killian Akehurst')
items.insert(:date => '2022-03-28', :store => 'BIE Store Jakarta', :total_price => 514384, :customer => 'Leta Sinnocke')
items.insert(:date => '2022-12-19', :store => 'BIE Store Palembang', :total_price => 925273, :customer => 'Jordain Labin')
items.insert(:date => '2022-07-22', :store => 'BIE Store Malang', :total_price => 920519, :customer => 'Vania Wyman')
items.insert(:date => '2023-03-01', :store => 'BIE Store Balikpapan', :total_price => 418826, :customer => 'Raye Ellerington')
items.insert(:date => '2022-09-25', :store => 'BIE Store Jakarta', :total_price => 568757, :customer => 'L;urette Casazza')
items.insert(:date => '2022-04-19', :store => 'BIE Store Malang', :total_price => 325586, :customer => 'Hermie Diggin')
items.insert(:date => '2022-04-09', :store => 'BIE Store Jakarta', :total_price => 893002, :customer => 'Cornall Eggar')
items.insert(:date => '2022-09-28', :store => 'BIE Store Balikpapan', :total_price => 681807, :customer => 'Stewart McPhail')
items.insert(:date => '2022-08-16', :store => 'BIE Store Jakarta', :total_price => 103808, :customer => 'Ilsa Allday')
items.insert(:date => '2022-05-06', :store => 'BIE Store Balikpapan', :total_price => 850712, :customer => 'Bobbi Oliphant')
items.insert(:date => '2022-10-20', :store => 'BIE Store Malang', :total_price => 733188, :customer => 'Alicia Balchen')
items.insert(:date => '2022-06-13', :store => 'BIE Store Palembang', :total_price => 326823, :customer => nil)
items.insert(:date => '2022-10-26', :store => 'BIE Store Malang', :total_price => 187993, :customer => 'Fan Youens')
items.insert(:date => '2023-03-09', :store => 'BIE Store Jakarta', :total_price => 600253, :customer => 'Pattin McGrowther')
items.insert(:date => '2022-10-03', :store => 'BIE Store Palembang', :total_price => 57693, :customer => 'Gaby Gumb')
items.insert(:date => '2022-07-23', :store => 'BIE Store Jakarta', :total_price => 828902, :customer => 'Bibbie Oger')




# calling run_sql will print the results and return them so that you can test data within them.
# if you want to test different sets of data, then its best to move this code into its own top level describe
# block. If you are only testing one set though, its better to set the results before you enter a describe block
# so that the results are presented at the top of the output.
results = run_sql

describe :test do
   it "Should return 90 items" do
    expect(results.count).to eq 90
   end
  it "All customer cannot be null" do
    results.each do |row|
      expect(row[:customer]).to_not eq nil
    end
  end
  
end


# Other tips about using run_sql:
# The SQL/code section supports multiple statements, seperated of course by a ";".
# When multiple SELECT statements are issued:
#    run_sql will return an array of arrays, unless only one SELECT statement returned results
#    INSERT and UPDATE results will not be included in the list
#    SELECT statements that return no results will not be included in the list