gistfile1.txt

SELECT * FROM t3;

SELECT TOP 6 * FROM t3;

INSERT INTO t3(f1, f2) VALUES
('aaa', 100),
('aaa', 200);

SELECT DISTINCT * FROM t3;

SELECT DISTINCT(f1) f1 FROM t3;

SELECT id 'Íîìåð', t3.f1 'Ïîëå 1', t3.f2 'Ïîëå 2' FROM t3;

SELECT TOP (SELECT COUNT(*) / 2 FROM t3) * FROM t3;

INSERT INTO t4(ff4) VALUES
('aaa'),
('abbc'),
('cbb'),
('acccb'),
('ammn'),
('aee'),
('beed'),
('bsd');

SELECT * FROM t4 WHERE ff4 LIKE '%c%';

SELECT * FROM t4 WHERE ff4 LIKE 'b%';

SELECT * FROM t4 WHERE ff4 LIKE '_[a-d]%';

SELECT * FROM t4 WHERE ff4 LIKE '%[ad]';

INSERT INTO t4(ff3) VALUES
(1),
(3),
(5),
(7),
(10),
(15),
(20),
(25),
(30);

SELECT * from t4 WHERE ff3 >= 5;

SELECT * FROM t4 WHERE ff3 BETWEEN 2 AND 20;

CREATE TABLE t5(
id int PRIMARY KEY IDENTITY(1,1),
fi int,
fv varchar(12),
fc char(12),
fnv nvarchar(12),
fnc nchar(12),
fd datetime
);

CREATE TABLE t6(
id int PRIMARY KEY IDENTITY(1,1),
fi int,
f2v varchar(12)
);

INSERT INTO t3(fi) VALUES
(10),
(20),
(30),
(40),
(50);

SELECT * FROM t5, t6 WHERE t5.fi = t6.fi;

SELECT * FROM t5, t6 WHERE t5.fi = t6.fi ORDER BY fv;

SELECT * FROM t5, t6 WHERE t5.fi = t6.fi ORDER BY f2v;

SELECT * FROM t5 WHERE fv IN ('Ñìèðíîâ', 'Ïîòàïîâ', 'Ìàêñèìîâ');

SELECT * FROM t5 WHERE fi BETWEEN 20 AND 40;

SELECT * FROM t5 WHERE fv LIKE '__ò%';

--34
ALTER TABLE t5 ADD fg int;
ALTER TABLE t5 ADD fp float;

--37
SELECT COUNT(*) FROM t5;
SELECT COUNT(*) FROM t5 WHERE fc IS NOT NULL

--38
SELECT MAX(fp), MIN(fp), AVG(fp) FROM t5;

--39
SELECT fg, MAX(fp), MIN(fp), AVG(fp) FROM t5 GROUP BY fg;

--40
SELECT fg, MAX(fp), MIN(fp), AVG(fp) FROM t5 WHERE fp > 10 GROUP BY fg;

--41
SELECT fg, MAX(fp), MIN(fp), AVG(fp) FROM t5 HAVING fp > AVG(fp) GROUP BY fg;

--42