编辑代码

CREATE DATABASE Fruits;
USE Fruits;

-- 创建表结构
CREATE TABLE Apples (
    ID VARCHAR(10) PRIMARY KEY,
    Name VARCHAR(50),
    Color VARCHAR(20),
    Origin VARCHAR(50),
    Sweetness VARCHAR(20)
);

-- 插入数据
INSERT INTO Apples (ID, Name, Color, Origin, Sweetness) VALUES
('A01', 'Red Delicious', 'Red', 'United States', 'Sweet'),
('A02', 'Granny Smith', 'Red', 'Australia', 'Tart'),
('A03', 'Gala', 'Orange', 'New Zealand', 'Medium'),
('A04', 'Fuji', 'Red', 'Japan', 'Very Sweet');

SELECT ID, Name
FROM Apples 
WHERE Sweetness IN ('Sweet', 'Very Sweet');