# 4 pts

# Create a table
statement ok
create table t1(v1 int, v2 varchar(128), v3 int);

# Insert once
query
insert into t1 values (0, '🥰', 10), (1, '🥰🥰', 11), (2, '🥰🥰🥰', 12), (3, '🥰🥰🥰🥰', 13), (4, '🥰🥰🥰🥰🥰', 14);
----
5

query
select * from t1;
----
0 🥰 10
1 🥰🥰 11
2 🥰🥰🥰 12
3 🥰🥰🥰🥰 13
4 🥰🥰🥰🥰🥰 14

# Delete from the table
query
delete from t1 where v1 >= 3
----
2

query
select * from t1;
----
0 🥰 10
1 🥰🥰 11
2 🥰🥰🥰 12

# Delete all
query
delete from t1;
----
3

query
select * from t1;
----

# Repeat
query
insert into t1 values (0, '🥰', 10), (1, '🥰🥰', 11), (2, '🥰🥰🥰', 12), (3, '🥰🥰🥰🥰', 13), (4, '🥰🥰🥰🥰🥰', 14);
----
5

query
select * from t1;
----
0 🥰 10
1 🥰🥰 11
2 🥰🥰🥰 12
3 🥰🥰🥰🥰 13
4 🥰🥰🥰🥰🥰 14

# Delete from the table
query
delete from t1 where v1 >= 3
----
2

query
select * from t1;
----
0 🥰 10
1 🥰🥰 11
2 🥰🥰🥰 12

# Delete nothing
query
delete from t1 where v1 != v1;
----
0

query
select * from t1;
----
0 🥰 10
1 🥰🥰 11
2 🥰🥰🥰 12

# Delete all
query
delete from t1;
----
3

query
select * from t1;
----