选择同一行的数据

Question

my table

我需要知道如何编写这样的代码:

如果account_id 2的quiz_num_1数据不为quiz_null则打印，如果account_id 2的quiz_num_1数据为quiz_null则打印不同的account_id可以通过变量名控制:user_account_id = 1或2

有人能帮我吗?我试着这样做，但不工作

mycursor.execute(f"SELECT account_id FROM quizzes_lib WHERE account_id = '{user_account_id}'AND SELECT quiz_num_1 FROM quizzes_lib WHERE quiz_num_1 = 'quiz_null'")
#mycursor.execute("SELECT quiz_num_1 FROM quizzes_lib Where quiz_num_1 = 'quiz_null'")
if mycursor.fetchall():
print("there is no quizzes in your library")
else:
print("there is __ in your library")

Answer 1

mycursor.execute(f"SELECT account_id, quiz_num_1 FROM quizzes_lib WHERE account_id = '{ user_account_id }' AND quiz_num_1 != 'quiz_null'")
if mycursor.fetchall():
print("there is quizzes in your library")
else:
print("no quizzes")