Which downtime activities cover lifestyle expenses?

I am puzzled by the interaction between Lifestyle and Downtime Activities, particularly as to lifestyle expenses.

One of the downtime options presented in the Player’s Handbook, p. 187, is Researching, which expressly states:

For each day of research, you must spend 1 gp to cover your expenses. This cost is in addition to your normal lifestyle expenses . . . .

More downtime options appear in the Dungeon Master’s Guide and Xanathar’s Guide to Everything, including several that have associated gold-per-day costs. But none of them state that their costs are in addition to a PC’s lifestyle expenses.

At the same time, certain downtime activities go out of their way to say lifestyle expenses are or might be covered during the activity. For example, Work, XGtE p. 134, contemplates an ability check the outcome of which determines what lifestyle one can maintain without cost during the activity. And Crafting, PHB p. 187, simply says:

While crafting, you can maintain a modest lifestyle without having to pay 1 gp per day, or a comfortable lifestyle at half the normal cost . . . .

In other words, the cost of Crafting subsumes one’s lifestyle costs, at least to an extent. Adding to the confusion is the fact that the downtime options in XGtE are wholly optional “alternatives” that differ from options in the PHB and DMG. There is basically no consistency among them.

Even more confusing, the DMG says, at p. 128, that while engaged in Carousing, a PC “spends money as though maintaining a wealthy lifestyle . . . .” (Emphasis mine.) To my eyes, that “as though” is ambiguous. Does the PC spend money on her normal lifestyle and on the wealthy lifestyle necessary for Carousing? Or does the later subsume the former, as with the PHB‘s version of Crafting?

In short: which downtime activities cover a PC’s lifestyle expenses while performing them, and which don’t?

UK Visa from India: Should I mention if conference organisers will be reimbursing some of my travel expenses?

There is a field in the visa form where it says if someone will be paying towards the cost of my visit.

My organizers will be reimbursing part of my travel. Right now, I don’t have it in writing(in the invitation letter) from the organizers.

So, should I say, no one will be paying?

MYSQL get the turnover , income, total expenses from my database and group them by year-month

I have 4 tables :

Products - to record products spending - to record expenses directv  - to record subscription payments to TV channels sales    - to record sales 

Products has 4 columns : idProd is the primary key

+--------+-----------+--------------+-------------+ | idProd | nameProd  | sellingPrice | buyingPrice | +--------+-----------+--------------+-------------+ |      1 | Iphone 8  |          500 |         400 | |      2 | Samsung 2 |          600 |         400 | +--------+-----------+--------------+-------------+ 

Spending – 3 columns and idSpd is the primary key

+-------+--------+------------+ | idSpd | amount | dateSpd    | +-------+--------+------------+ |     1 |   1000 | 2018-11-01 | |     2 |   1000 | 2018-11-01 | |     3 |   1000 | 2018-10-01 | |     4 |   4000 | 2018-10-01 | +-------+--------+------------+ 

Sales – 5 columns with idSale as primary key and idProd to link it to the product’s table

+--------+--------+--------------+----------+------------+ | idSale | idProd | sellingPrice | quantity | dateSale   | +--------+--------+--------------+----------+------------+ |      1 |      1 |          700 |        2 | 2018-11-01 | |      2 |      1 |          700 |        5 | 2018-11-15 | |      3 |      2 |          800 |        2 | 2018-11-16 | +--------+--------+--------------+----------+------------+ 

and directv :

+-------+-----------------+-------+------------+ | idDtv | brand           | price | dateDtv    | +-------+-----------------+-------+------------+ |     1 | channel decoder |   150 | 2018-11-09 | +-------+-----------------+-------+------------+ 

and I wish to get for example :

income|gain of product  |  turnover | Spending | DirecTv | month | year 1000  |     400         | 5500      | 3000     | 50      | 10     |2018 500   |     200         |  1000     | 2000     | 0       | 11     |2018 

my queries :

--for directv select sum(dv.price) , month(dv.dateDtv), year(dv.dateDtv) from directv dv GROUP by year(dv.dateDtv) , month(dv.dateDtv)   --for turnover select sum(sl.quantity*sl.sellingPrice) , month(sl.dateSale) , year(sl.dateSale) from sales sl GROUP by year(sl.dateSale) , month(sl.dateSale)  --for spending select sum(spd.amount) , month(spd.dateSpd) , year(spd.dateSpd) from spending spd GROUP by year(spd.dateSpd) , month(spd.dateSpd)   --for gain of product SELECT sum(s.quantity*(s.sellingPrice-p.buyingPrice)) from sales s JOIN products p on s.idProd = p.idProd GROUP by year(s.dateSale) , month(s.dateSale)  

and income = gain of product + directv – spending

but i want joins all these queries and calculate the income , someone could help me ? it was okay but i was unable to combine with my new table product today