how can i send a list of tuples from the server to the client using sockets?

[Larz60+]

SQL has built-in for getting count of query.
simple example: select count(mycolumn) from mytable where myfilter;
for the socket part, see: https://docs.python.org/3.8/howto/sockets.html