CREATE TABLE Type_Of_Restaurant (Id VARCHAR2)
CREATE TABLE Restaurant (Id VARCHAR2)
CREATE TABLE Restaurant_Type (Id VARCHAR2)

How many restaurant is the Sandwich type restaurant?
SELECT COUNT(*) FROM Restaurant JOIN Type_Of_Restaurant ON Restaurant.ResID = Type_Of_Restaurant.ResID JOIN Restaurant_Type ON Type_Of_Restaurant.ResTypeID = Restaurant_Type.ResTypeID GROUP BY Type_Of_Restaurant.ResTypeID HAVING Restaurant_Type.ResTypeName = 'Sandwich'
SELECT COUNT(*) FROM "Restaurant" JOIN "Type_Of_Restaurant" ON "Restaurant"."ResID" = "Type_Of_Restaurant"."ResID" JOIN "Restaurant_Type" ON "Restaurant_Type"."ResTypeID" = "Type_Of_Restaurant"."ResTypeID" GROUP BY "Type_Of_Restaurant"."ResTypeID" HAVING "Restaurant_Type"."ResTypeName" = 'Sandwich'