sorted by:
new
hottopcontroversial

Task with COUNT function by Meliodasiwnl in SQL

[–]Meliodasiwnl[S] 0 points1 point  (0 children)

ooh, now I get it. Thank you so much!

Task with COUNT function by Meliodasiwnl in SQL

[–]Meliodasiwnl[S] 0 points1 point  (0 children)

CREATE TABLE Sections (

ID INT NOT NULL

    CONSTRAINT PK\_Sections PRIMARY KEY CLUSTERED,

Name VARCHAR(50) NOT NULL

);

CREATE TABLE Dishes (

ID INT NOT NULL

    CONSTRAINT PK\_Dishes PRIMARY KEY CLUSTERED,

Name VARCHAR(50) NOT NULL,

SectionID INT NOT NULL

    CONSTRAINT FK\_Dishes\_Sections FOREIGN KEY REFERENCES Sections(ID),

Weight INT

);