FromMeloriWithLove

1)
SELECT user_id, nick, age, education.name, drinking.name, smoking.name
FROM users
JOIN education ON users.id_education = education.id
JOIN drinking ON users.my_drink = drinking.id
JOIN smoking ON users.my_smoke = smoking.id
WHERE education.name = 'высшее' AND drinking.name = 'не пью вообще' AND smoking.name = 'не курю'

2)
SELECT user_id, nick, age, eyescolor.name, haircolor.name, gender.name

FromMeloriWithLove

SELECT
    DB_NAME(database_id) AS DatabaseName,
    SUM(size) * 8 AS SizeInBytes
FROM
    sys.master_files
WHERE
    database_id > 4
GROUP BY
    database_id
ORDER BY