## mail.app – How to display the number of unread emails in the Mail app in the Mac OS menu bar?

How best to display the number of unread emails in the Mail app on Mac OS? menu bar? (Bonus points, if I can use it to open the mail app.)

I do not really use the dock and got used to apps like Airmail and Fantastical that use the Mac OS menu bar to show information such as: the number of unread emails.

The best thing I could find after a quick search was https://www.macupdate.com/app/mac/22042/mail-unread-menu (from this thread), apparently it was not updated in ~ 6 years and may not work without also installing the MailPluginFix plugin. Is that really the best way to do that?

I use Mojave.

## html5 – ID, where the first character is a number, does not work if I enter css #[número de exemplo]

For example, if I entered the HTML code:

``` texto de teste ```

and I will put in CSS: `#1 {código de teste}`, does not recognize that `id=1`, Even if I set "class" instead of "id", or if I set a different tag or number. Is that a problem with my code? Or is it normal? Why is this happening?

## iCloud – iOS 12.3.2 Messages.app still associates a deleted / outdated phone number with a Contact.app listing: how do you fix the problem?

How do I fix # 4 in the following scenario?

Day 1: Contacts.app Entry X contains mobile phone numbers A and B.

Day 2: Contacts.app entry X contains the mobile number A.

Also on the 2nd day:

1. (good) macOS Contact.app no ​​longer links B to entry X.
2. (good) macOS Messages.app no ​​longer links B to X.
3. (good) iCloud.com Contacts no longer binds B to X.
4. (BAD) iOS 12.3.2 Messages.app still links B to Contacts.app entry X.

To fix # 4, I've tried (several times) to restart my iOS (an iPhone 8), reboot iOS Messages.app and Contacts.app, and even add a new Contacts.app listing with the old phone number (try to "redirect" B to another Contacts.app entry), which reflects everything in # 1, # 2 and # 3 well … but not # 4.

Considerations for the remedy?

I would like avoid Delete iOS Messages.app threads associated with B. And I am not sure if this would also lead to a correction. However, I did not try it because I want to keep the message threads / data / photos.

## Number theory – Find the field extension that corresponds to a subgroup of the Galois group of roots of the unit

Suppose I extend the rationals around all pth roots of the unit, where p is a prime number. The Galois group of this extension would be integers modulo p-1, there is a unique subgroup of index 2, which is generated by 2. I would like to find the corresponding field extension with degree two.

I could do the job if p = 5, but that's easy, since the only nontrivial element of the subgroup of index two is conjugation.

How do I do this task when p gets big, say 71? The generator of the multiplicative group is here 7, so I should look for x so that x ^ 7 = x, I have no idea how to go about it.

## olap – Maximum number of table columns in Clickhouse

I tried to test the bounds and found that for 5K columns in the table, one appears, even if only 2 columns are inserted
Obtained from 127.0.0.1:9000. DB :: Exception: memory limit exceeded (for query): would use 9.31 GiB

Is there a way to deal with an extremely large number of metrics?

## SQL Server – Number of MAX DATE, MIN DATE, and Active Counts

1. GLUSR_USR_ID
2. First meeting date (after each GLUSR ID)
3. Date of the last meeting (after each GLUSR_ID)
4.Total Meeting Count (after each GLUSR ID)
4. Date of the last meeting (after each GLUSR_ID)
5. Total meeting in the last 90 days (after each GLUSR_ID)
6.Total session in the last 180 days (after each GLUSR_ID)
7.Active status in the last 30 days (number of meetings)
I have attached the pictures as a reference

`

```````Select GLUSR_USR_ID,
( select  Count(1) from STS_DSR_SALES@mainr where
STS_DSR_SALES.FK_STS_COMPANY_ID=O.FK_STS_COMPANY_ID)S_COUNT,

(Select MAX(STS_DSR_SALES_DATE)
from STS_DSR_SALES@mainr where STS_DSR_SALES.FK_STS_COMPANY_ID=O.FK_STS_COMPANY_ID)MAX_DATE,

(Select min(STS_DSR_SALES_DATE)
from STS_DSR_SALES@mainr where STS_DSR_SALES.FK_STS_COMPANY_ID=FK_STS_COMPANY_ID)Min_DATE,

(Select count (1) STS_DSR_SALES_DATE from STS_DSR_SALES@mainr
where STS_DSR_SALES.FK_STS_COMPANY_ID= FK_STS_COMPANY_ID and trunc(STS_DSR_SALES_DATE)>SYSDATE-90)Active_90,

( select  Count(1) from STS_DSR_SALES@mainr where STS_DSR_SALES.FK_STS_COMPANY_ID=O.FK_STS_COMPANY_ID)S_COUNT,

(Select MAX(STS_DSR_SALES_DATE)
from STS_DSR_SALES@mainr where STS_DSR_SALES.FK_STS_COMPANY_ID=O.FK_STS_COMPANY_ID)MAX_DATE,

(Select min(STS_DSR_SALES_DATE)
from STS_DSR_SALES@mainr where STS_DSR_SALES.FK_STS_COMPANY_ID=FK_STS_COMPANY_ID)Min_DATE,

(Select count (1) STS_DSR_SALES_DATE from STS_DSR_SALES@mainr
where STS_DSR_SALES.FK_STS_COMPANY_ID= FK_STS_COMPANY_ID and trunc(STS_DSR_SALES_DATE)>SYSDATE-90)Active_90,

(Select count (1) STS_DSR_SALES_DATE from STS_DSR_SALES@mainr
where STS_DSR_SALES.FK_STS_COMPANY_ID= FK_STS_COMPANY_ID and trunc(STS_DSR_SALES_DATE)>SYSDATE-180)Active_180,

(Select Count (1)STS_DSR_SALES_DATE from STS_DSR_SALES@mainr
where STS_DSR_SALES.FK_STS_COMPANY_ID= S.FK_STS_COMPANY_ID and TRUNC(REPORT_DATE)>SYSDATE-30)ACTIVE_30

From
(select GLUSR_USR_ID,fk_sts_company_id,GLUSR_USR_CUSTTYPE_NAME from STS_DSR_SALES@mainr,GLUSR_USR@mainr
where  trunc(sts_dsr_sales_date) between '01-oCT-19' and '31-oCT-19')O,
(Select fk_sts_company_id, REPORT_DATE FROM GLUSR_CLCKSTRM_4HOTLEAD_ARCH@mainr,STS_DSR_SALES@mainr where TRUNC(REPORT_DATE)>SYSDATE-30)S
``````

Note

GLUSR_USR_ID is the employee ID
The total number of meetings can be retrieved with the total number. from (STS_DSR_SALES_DATE),
First meeting is Max Date
Last meeting is a minimum date
The total number of meetings in the last 90 days and 180 days equals the number of meetings in the previous days
active in 30 days is totally no. of the meeting
I get the wrong data because GLUSR_ID is matched by total meeting counts. That's wrong. I would like to format my data from picture 2 and 3 like picture 1.

## Number theory – summation elements in a two-dimensional arithmetic sequence

I have two matrices,

$$A = left ( begin {matrix} 5 & 10 & 15 & cdots \ 17 & 28 & 39 & cdots \ 35 & 52 & 69 & cdots \ vdots & vdots & vdots & ddots end {matrix} right)$$

$$B = left ( begin {matrix} 6 & 13 & 20 & cdots \ 18 & 31 & 44 & cdots \ 36 & 55 & 74 & cdots \ vdots & vdots & vdots & ddots end {matrix} right)$$
From where
begin {align *} a_ {i, j} & = 3i ^ 2 + (6j – 3) i – j \ b_ {i, j} & = 3i ^ 2 + (6j-3) i + (j-1) end {align *}
How to prove that the sum of two elements of $$A$$ and $$B$$ Must be equal to the sum of two numbers, both of which are not elements $$A$$ and $$B$$?

e. G.:

$$a_ {1,1} + b_ {1,1} = 5 + 6 = 11 = 8 + 3$$,both $$8.3$$ are not elements of A and B.
$$a_ {1,1} + b_ {1,2} = 5 + 13 = 18 = 14 + 4$$,both $$14.4$$ are not elements of A and B.

This question, which was asked 5 years ago at MSE, has no answer. That's why I put it here.

## At the moment I can only answer a call on the GM number

I have a Google Voice number associated with my iPhone number. How do I activate the GV number to make calls? At the moment I can only answer a call on the GM number