import sqlite3
con = sqlite3.connect(r'C:\Users\asus\PycharmProjects\YKR\YKR\reports_db.sqlite')
cur = con.cursor()
line_for_search = '1'
for tablename in cur.execute("select name from sqlite_master where type = 'table'"):
print('SELECT * FROM {} WHERE Line="{}"'.format(tablename[0], line_for_search))
select e.mark, course, g.name, s.name, lastname, surname, p.name, f.name from students s
left join groupa g on s.group_id = g.id
inner join exam_mark e on s.id = e.student_id
inner join peciality p on g.peciality_id = p.id
inner join facult f on p.facult_id = f.id
where e.mark >= 4
and not exists (select 1
from exam_mark e1
where e1.student_id = s.id
and e1.mark <> 2)
SELECT
tt.`email`,
COUNT(tt.`email`) AS `count`
FROM
`e_stat` AS tt
WHERE NOT EXISTS (
SELECT 1
FROM `e_stat`
JOIN `pb`
ON `pb`.`e_stat_id` = `e_stat`.`id`
WHERE `e_stat`.`msg` = '68'
AND `e_stat`.`email` = tt.`email`)
GROUP BY tt.`email`