Hi there !
I hope you’re doing good!
I’ve a question about the final project of the SQL course, in the ‘Implementing Index Scans’ part to be more precise. The goal is to create index to perform our queries.
I don’t know why, but I can’t make the question #4 with that answer below
create index ix_ip_where on customers(ip_address) where ip_address = '220.127.116.11';
I got the same case with the question #6:
create index ix_jr on customers(suffix)
I tried to remove the indexes but it’s still wrong… do you have any ideas?