SELECT Name FROM customer ORDER BY Level_of_Membership ASC
Sort all the customers by the level of membership in ascending order, and return the customer names.
CREATE TABLE "customer" (
"Customer_ID" int,
"Name" text,
"Nationality" text,
"Card_Credit" real,
"Level_of_Membership" int,
PRIMARY KEY ("Customer_ID")
);
CREATE TABLE "branch" (
"Branch_ID" int,
"Manager" text,
"Years_opened" int,
"Location_of_office" text,
PRIMARY KEY ("Branch_ID")
);
CREATE TABLE "customer_order" (
"Customer_ID" int,
"Branch_ID" int,
"Dish_Name" text,
"Quantity" int,
PRIMARY KEY ("Customer_ID","Branch_ID","Dish_Name"),
FOREIGN KEY ("Customer_ID") REFERENCES `customer`("Customer_ID"),
FOREIGN KEY ("Branch_ID") REFERENCES `branch`("Branch_ID")
);
INSERT INTO  "customer" VALUES (1,"Arthur Morris","Australia","87.00","3");
INSERT INTO  "branch" VALUES (1,"Ashby Lazale",5,"Hartford");
INSERT INTO  "customer_order" VALUES (2,10,"Ma Po Tofu",1);