In class we made a FruitTable with the fields fruitID, fruitName, price, quantity, supplier and delivery date. We're practicing select statements and I'm stuck on these question:
select max(price*quantity) from FruitTable as maxprofit
You are almost there with the first one.
select * from FruitTable WHERE price * quantity = (SELECT max(price*quantity) FROM FruitTable)
The second one (returning row having the same first letter in FruitName and Supplier name) is
SELECT * FROM FruitTable WHERE SUBSTRING(fruitName, 1, 1) = SUBSTRING(supplier, 1, 1)