Question

solve:

• Write a single SQL statement to create a new table named Login with five columns: User(Text), Password (Text), Update (Date), Status (Text) and CustomerID (Integer)

  • Set the default value of LastUpdate to the current date and time ( time)
  • Define a check on Status to make sure the value could either be 'active' or 'inactive'
• and
• Write a single SQL statement to list all the tracks that have the exact word 'hello' (including both upper and lower cases) as part of the name in the Track table. In other words, it will not include track names with words like 'hellos' or 'helloous' in the output

Answer 1

SQL Queries

1)
CREATE TABLE Login(
User TEXT,
Password TEXT,
Update DATE DEFAULT CURRENT_TIMESTAMP, // this will default to current date and time
Status TEXT(255) CHECK (Status='active' OR Status='inactive'), // this check constraint will check if status is active or inactive and no other value
CustomerID INTEGER
);

2)
SELECT * FROM Track WHERE LOWER(name)=LOWER('Hello');  

if you like the answer please provide a thumbs up.