Ad
landakbotakvs.rishadharis

Basic Use Case 2 LIMIT (BIE)

Code
Diff
  • select * from employees
order by salary desc
limit 10;
    • -- Code Here
    • select * from employees
    • order by salary desc
    • limit 10;
landakbotakvs.rishadharis

Basic Ordering 3 Multiple Order (BIE)

Code
Diff
  • select * from transactions
where customer is not null
order by store asc, total_price desc;
    • -- Code Here
    • select * from transactions
    • where customer is not null
    • order by store asc, total_price desc;
landakbotakvs.rishadharis

Basic Ordering 2 DESC (BIE)

Code
Diff
  • select * from transactions
order by  total_price desc;
    • -- Code Here
    • select * from transactions
    • order by total_price desc;
landakbotakvs.rishadharis

Basic Ordering 1 ASC (BIE)

Code
Diff
  • select * from transactions
order by  total_price asc;
    • -- Code Here
    • select * from transactions
    • order by total_price asc;
landakbotakvs.rishadharis

Basic Filtering 6 Like (BIE)

Code
Diff
  • select * from transactions
where customer like 'S%r';
    • -- Code Here
    • select * from transactions
    • where customer like 'S%r';
landakbotakvs.rishadharis

Basic Filtering 8 Is Not (BIE)

Code
Diff
  • select * from transactions
where customer is not null;
    • -- Code Here
    • select * from transactions
    • where customer is not null;
landakbotakvs.rishadharis

Basic Filtering 7 Is (BIE)

Code
Diff
  • select * from transactions
where customer is null;
    • -- Code Here
    • select * from transactions
    • where customer is null;
landakbotakvs.rishadharis

Basic Filtering 5 Not In (BIE)

Code
Diff
  • select * from transactions
where store not in ('BIE Store Jakarta','BIE Store Bandung');
    • -- Code Here
    • select * from transactions
    • where store not in ('BIE Store Jakarta','BIE Store Bandung');
landakbotakvs.rishadharis

Basic Filtering 4 In (BIE)

Code
Diff
  • select * from transactions
where store in ('BIE Store Bandung',
'BIE Store Palembang',
'BIE Store Malang');
    • -- Code Here
    • select * from transactions
    • where store in ('BIE Store Bandung',
    • 'BIE Store Palembang',
    • 'BIE Store Malang');
landakbotakvs.rishadharis

Basic Filtering 3 (BIE)

Code
Diff
  • select date, store, total_price from transactions
where date between '2022-01-01' and '2022-01-03'
;
    • -- Code Here
    • select date, store, total_price from transactions
    • where date between '2022-01-01' and '2022-01-03'
    • ;
landakbotakvs.rishadharis

Basic Filtering 2 AND and Relational Condition (BIE)

Code
Diff
  • select * from transactions
where store= 'BIE Store Bandung'
and total_price <= '100000'
;
    • -- Code Here
    • select * from transactions
    • where store= 'BIE Store Bandung'
    • and total_price <= '100000'
    • ;
landakbotakvs.rishadharis

Basic Filtering 1 (BIE)

Code
Diff
  • select * from customers
where kota = 'Tasikmalaya'
;
    • -- Code here
    • select * from customers
    • where kota = 'Tasikmalaya'
    • ;
landakbotakvs.rishadharis

Basic Select with Alias (BIE)

Code
Diff
  • -- Code Here
select name as nama, age as umur from customers;
    • --- Code Here
    • -- Code Here
    • select name as nama, age as umur from customers;
landakbotakvs.rishadharis

Basic Select 2 (BIE)

Code
Diff
  • -- Code Here

select name, age from customers;
    • --- Code Here
    • -- Code Here
    • select name, age from customers;
landakbotakvs.rishadharis

Basic Select (BIE)

Code
Diff
  • -- Code here
select * from customers;
    • -- Code here
    • select * from customers;