data source: US IRS `individual personal` Tax Returns 2016 *based on public data
Multiplier is my own algorithm. USA median is about 220 :: Rank or 1.000
this is the complex stuff; and it really isn't once composed as a query
***need to SET the variable FIRST
oops
mysql> SET @INCaffinity:=(SELECT
-> affinity
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0201M' AND year=2017);
Query OK, 0 rows affected (0.33 sec)
mysql> SELECT
-> "All USA Consumers" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0201M' AND year=2017
-> UNION ALL
-> SELECT
-> "Less than $15,000" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0218M' AND year=2017
-> UNION ALL
-> SELECT
-> "$15,000 to $29,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0219M' AND year=2017
-> UNION ALL
-> SELECT
-> "$30,000 to $39,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0207M' AND year=2017
-> UNION ALL
-> SELECT
-> "$40,000 to $49,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0208M' AND year=2017
-> UNION ALL
-> SELECT
-> "$50,000 to $69,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0209M' AND year=2017
-> UNION ALL
-> SELECT
-> "$70,000 to $99,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0220M' AND year=2017
-> UNION ALL
-> SELECT
-> "$100,000 to $149,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0221M' AND year=2017
-> UNION ALL
-> SELECT
-> "$150,000 to $199,999" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0222M' AND year=2017
-> UNION ALL
-> SELECT
-> "$200,000 and more" AS "Cellular phone by Income Range:",
-> year,
-> (affinity/@INCaffinity) AS "Affinity Index"
-> FROM change_pct_cx WHERE series_id = 'CXU270102LB0223M' AND year=2017
-> ORDER BY `Affinity Index`DESC
-> ;
+---------------------------------+------+----------------+
| Cellular phone by Income Range: | year | Affinity Index |
+---------------------------------+------+----------------+
| $200,000 and more | 2017 | 1.7182 |
| $150,000 to $199,999 | 2017 | 1.6055 |
| $100,000 to $149,999 | 2017 | 1.4410 |
| $70,000 to $99,999 | 2017 | 1.2460 |
| $50,000 to $69,999 | 2017 | 1.0599 |
| All USA Consumers | 2017 | 1.0000 |
| $40,000 to $49,999 | 2017 | 0.8980 |
| $30,000 to $39,999 | 2017 | 0.8426 |
| $15,000 to $29,999 | 2017 | 0.5760 |
| Less than $15,000 | 2017 | 0.4195 |
+---------------------------------+------+----------------+
10 rows in set (1.47 sec)
this indicates people that pay for service and probably pay for most mobile phone userd. This is NOT mobile phone USAGE by income group.
Welcome to Our Community
Wanting to join the rest of our members? Feel free to sign up today.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.
Attention: "role based name" email prefixes such as support, webmaster, info, contact, forum, service, affiliate, admin, traffic, partners, marketing, etc., for our member accounts are not permitted. They are acceptable for a vendor listing, but not for the member email. This is due to bulk email processors scrubbing them for delivery due to extremely high bounce rates. Please apply for membership using a personalized email prefix. Something like bob@xxxxx.com.
If we discover you signed up with a role based name we will give you only one message to change it. After 3 days your account will be removed if the email is not changed.