ΘΕΜΑ: Πώς μπορώ να συνδέσω δύο ερωτήματα στην sql

cur.execute ('''SELECT id, Name, LastName, Product, Amount FROM table WHERE Onoma='%s' AND Lastonoma = '%s' ''' %(box1.get(), box2.get())) 

SELECT Product FROM table SUM (amount) FROM table GROUP BY Product;

select (name ||" " || lastname) as fname, sum(amount) from tests group by fname;

select name, lastname,  sum(amount) from tests group by name, lastname;

cur.execute ('''SELECT id, Name, LastName, Product, Amount FROM table WHERE Onoma='%s' AND Lastonoma = '%s' ''' %(box1.get(), box2.get()))

value=StringVar()
box1=ttk.Combobox(Leftframe, textvariable=value)
box1['values'] = ('Κυριακή','Δευτέρα','Τρίτη','Τετάρτη','Πέμπτη','Παρασκευή','Σάββατο')
box1.current(0)
box1.grid(column=1, row=5,padx=21, pady=5)
box1.config(width=30, justify=RIGHT, font=('Times', 12))
box1.get()

import tkinter
from tkinter import *
from tkinter import ttk
 
root = Tk() 
the_value=StringVar()
 
def testme(event):
    print(the_value.get())
 
 
box1=ttk.Combobox(root, textvariable=the_value) 
box1['values'] = ('Κυριακή','Δευτέρα','Τρίτη','Τετάρτη','Πέμπτη','Παρασκευή','Σάββατο') 
box1.current(0) 
box1.grid(column=1, row=5,padx=21, pady=5) 
box1.config(width=30, justify=RIGHT, font=('Times', 12))
box1.bind('<<ComboboxSelected>>', testme)
 
#box1.get()
 
root.mainloop()