Have bosses can answer the first four item 2, 5, 6 of the second and third item

CodePudding user response:

The first item:
The create view2
As
Select
Gender,
Count (*) as the number of
The from
Table
Group by
gender

CodePudding user response:

The second item:


CREATE PROCEDURE JYINS
(
IN the incoming Numbers VARCHAR (8),
State OUT the returned books VARCHAR (8)
)
LANGUAGE SQL

P1: the begin

Declare the book state variable char (1);

Select
Colom (book status column names)
State variables into books
From table name
Where
Book number column=incoming book number


The set of books state variable state=return books

P1 end;