Q1hard
A database administrator needs to change the data type of the
phone_number column from INT to VARCHAR(20) in an existing Contacts table. Which
SQL command should be used?
sql-logic-test
-- Table Data: (id, category, stock)
-- 1, 'A', 10
-- 2, 'B', 50
-- 3, 'A', 100
SELECT * FROM inventory
WHERE category = 'A' OR category = 'B' AND stock > 60;