How do i make this more readable/"dry"

Getting Started Newbie Questions
#21

i know it annoying but i did post the table in the OP

#22

what is the problem you have?

#23

there is no problem i am just querying how i can improve the quality of my code/readibility

#24

If your code is not broken? then don’t worry about it.

#25

but always wrap DB code in BEGIN/END transaction code