Sobes.tech
Junior — Middle

Do you have experience in writing and executing SQL queries?

sobes.tech AI

Answer from AI

Yes, I have experience in writing and executing SQL queries. For example, to select data from a table, you can use a query:

SELECT id, name, email FROM users WHERE active = 1;

In Python, libraries such as sqlite3 or psycopg2 for PostgreSQL are often used to execute such queries. An example using sqlite3:

import sqlite3

conn = sqlite3.connect('example.db')
cursor = conn.cursor()
cursor.execute('SELECT id, name FROM users WHERE active = 1')
rows = cursor.fetchall()
for row in rows:
    print(row)
conn.close()