Hope to get the results
Total visits c user c1 order quantity conversion into
1000 200 500 500/1000 500/200

Table 1
The resource (total visits) record (c)
1000, 200,

Table 2
The order (orders)
500

Consult a great god

CodePudding user response:

 SELECT the resource record, order, order/resource, order/record FROM table 1 and table 2 

Two tables is only a record is available