import mysql.connector

conn = mysql.connector.connect(
    host='85.215.144.168',
    port=3306,
    user='asesoft',
    password='Pantera1',
    database='pastelerias'
)
cursor = conn.cursor()
cursor.execute('SELECT nombre, apellidos, nombre_corto FROM ge_trabajadores LIMIT 15')
for row in cursor.fetchall():
    print(row)

cursor.execute("SELECT COUNT(*) FROM ge_trabajadores WHERE apellidos IS NOT NULL AND apellidos != '' AND nombre LIKE CONCAT('%', apellidos)")
print('Count where nombre ends with apellidos:', cursor.fetchone()[0])
cursor.execute('SELECT COUNT(*) FROM ge_trabajadores')
print('Total trabajadores:', cursor.fetchone()[0])

conn.close()