gill-sama

type usernameOnly struct {
	username string`bson:"username"`
}
var user usernameOnly
users...Decode(&user)

type Expense  struct {
Category  string  `bson:"category"`
Amount   float    `bson:""amount"`
}
type MyDoc struct {
ID           primitive.ObjectID `bson:"_id, omitempty"`
ChatID       int                      `bson:"chatID"`
Expenses     []Expense              `bson:"expense"`
Income       []int(тип какой хотите) `bson:"income"`

myDoc = MyDoc{}
err = mongo.FindOne(context.TODO(),  {}).Decode(&myDoc)  
}

select t1.id, t1.name, min(t1.date), count(*) from test t1
join test t2 on t1.name = t2.name and t1.date BETWEEN t2.date-'5 seconds'::interval and t2.date+'5 seconds'::interval
group by t1.id, t1.name
having count(*) >1

from urllib import parse
parse.unquote('%D0%9F%D1%80%D0%B8%D0%B2%D0%B5%D1%82.mp4')

def my_list(path):
    result = []
    for dirname, dirnames, filenames in os.walk(path):
        filenames = filter(lambda x: x.endswith('.html'), filenames)
        for filename in filenames:
            file = os.path.join(dirname, filename)
            result.append(file)
    return result

table products (id serial, category_id small int, name text, vendor text)
table property(id serial,name text,  value)
table product_property(product_id big int, property_id big int)

select g.id, g.name, g.description, g.bar_code, s.count as total_sales, r.count as total_receipts, r.count-s.count as total  from good g join (select good_id, count(*) from receipt group by good_id) r on g.id = r.good_id
join (select good_id, count(*) from sale group by good_id) s on g.id = s.good_id

select sum(e.salary) as sum, d.id as d_id from employee e join department d on e.department_id = d.id group by d.id

select chief_id, t.sum-budget as overdraft from department d 
join
 (select sum(e.salary) as sum, d.id as d_id from employee e join department d on e.department_id = d.id group by d.id) t
 on t.d_id = d.id
where  t.sum>budget