Action camera companies such as GoPro and Sony makes their users believe they can take pro quality videos simply by purchasing their product

REVL

Author(s): (1) Gopal Yadav, Department of Physics, Indian Institute of Technology & Chennai Mathematical Institute. Table of Links Abstract & Introduction Brief Review of Wedge Holography Emerging Multiverse from Wedge Holography Application to Information Paradox Application to Grandfather Paradox Conclusion Acknowledgements and References Acknowledgements The author is supported by a Senior Research Fellowship (SRF) from the Council of Scientific and Industrial Research (CSIR), Govt. of India. It is my pleasure to thank Aalok Misra, who motivated me to work on the entanglement stuff, and for his blessings. We would also like to thank Juan Maldacena, Andreas Karch, Kostas Skenderis and Tadashi Takayanagi for very helpful discussions and comments. This research was also supported in part by the International Centre for Theoretical Sciences (ICTS) for the program “Nonperturbative and Numerical Approaches to Quantum Gravity, String Theory and Holography” (code:ICTS/numstrings-2022/8). Various conferences/workshops; e.g., Mysteries of Universe-I (Institute Lecture Series) and Indian Strings Meeting 2021 at Indian Institute of Technology Roorkee, Roorkee, India; Applications of Quantum Information in QFT and Cosmology at the University of Lethbridge, Canada; Kavli Asian Winter School (KAWS) on Strings, Particles and Cosmology (Online) at International Centre for Theoretical Sciences (ICTS) Bangalore, India (code:ICTS/kaws2022/1); Reconstructing the Gravitational Hologram with Quantum Information at Galileo Galilei Institute for Theoretical Physics, Florence, Italy; Quantum Information in QFT and AdS/CFT-III at Indian Institute of Technology Hyderabad, India; helped me to learn about the information paradox and related stuff. I am very thankful to the speakers and organizers of these conferences because I learned about the subject from these conferences. References [1] S.W. Hawking, Particle Creation by Black Holes, Commun. Math. Phys. 43, 199 (1975) Erratum: [Commun. Math. Phys. 46, 206 (1976)]. [2] D.N. Page, Information in Black Hole Radiation, Phys.Rev.Lett. 71 (1993) 3743-3746 [arXiv:hep-th/9306083 [hep-th]]. [3] J. M. Maldacena, The Large N limit of superconformal field theories and supergravity, Int. J. Theor. Phys. 38, 1113-1133 (1999) [arXiv:hep-th/9711200]. [4] Y. Ling et al, Reflected entropy in double holography, JHEP 02 (2022) 037 [arXiv:2109.09243]. [5] C. Krishnan, Critical Islands, JHEP 01 (2021) 179 [arXiv:2007.06551[hep-th]]. [6] E. Caceres, A. Kundu, Ayan K. Patra and S. Shashi, Page Curves and Bath Deformations [arXiv:2107.00022 [hep-th]]. [7] E. Caceres, A. Kundu, Ayan K. Patra and S. Shashi, Warped information and entanglement islands in AdS/WCFT, JHEP 07 (2021) 004 [arXiv:2012.05425 [hep-th]]. [8] A. Bhattacharya, A. Bhattacharyya, P. Nandy and A.K. Patra, Islands and complexity of eternal black hole and radiation subsystems for a doubly holographic model, JHEP 05 (2021) 135 [arXiv:2103.15852[hep-th]]. [9] A. Bhattacharya, A. Bhattacharyya, P. Nandy and A.K. Patra, Bath deformations, islands and holographic complexity, Phys. Rev. D 105 (2022) 066019 [arXiv:2112.06967[hep-th]]. [10] Q.L. Hu, D. Li, R.X. Miao and Y.Q. Zeng, AdS/BCFT and Island for curvature-squared gravity, [arXiv:2202.03304[hep-th]]. [11] Y. Ling, Y. Liu and Z. Y. Xian, Island in Charged Black Holes, JHEP 03 (2021) 251 [arXiv:2010.00037[hep-th]]. [12] H. Omiya and Z. Wei, Causal Structures and Nonlocality in Double Holography [arXiv:2107.01219[hep-th]]. [13] H. Geng, A. Karch, C.P. Pardavila, S. Raju and L. Randall, Entanglement Phase Structure of a Holographic BCFT in a Black Hole Background, [arXiv:2112.09132[hep-th]]. [14] M. Afrasiar, J.K. Basak, A. Chandra and G. Sengupta, Islands for Entanglement Negativity in Communicating Black Holes [arXiv:2205.07903[hep-th]]. [15] D. Basu, H. Parihar, V. Raj and G. Sengupta, Defect extremal surfaces for entanglement negativity [arXiv:2205.07905[hep-th]]. [16] Y. Liu, Z.Y. Xian, C. Peng and Y. Ling, Black holes Entangled by Radiation, [arXiv:2205.14596[hep-th]]. [17] Z. Li and R.Q. Yang, Upper bounds of holographic entanglement entropy growth rate for thermofield double states, [arXiv:2205.15154[hep-th]]. [18] F. Deng, Y.S. An and Y. Zhou, JT Gravity from Partial Reduction and Defect Extremal Surface, [arXiv:2206.09609[hep-th]]. [19] C.F. Uhlemann, Islands and Page curves in 4d from Type IIB, JHEP 08 (2021) 104 [arXiv:2105.00008[hep-th]]. [20] S. Demulder, A. Gnecchi, I. Lavdas and D. Lust, Island and Light Gravitons in type IIB String Theory, [arXiv:2204.03669[hep-th]]. [21] A. Karch, H. Sun and C.F. Uhlemann, Double holography in string theory, [arXiv:2206.11292[hep-th]]. [22] H. Geng, Y. Nomura and H. Y. Sun, Information paradox and its resolution in de Sitter holography, Phys.Rev.D 103 (2021) 12, 126004 [arXiv:2103.07477[hep-th]]. [23] G. Yadav and A. Misra, (“Swiss-Cheese”) Entanglement Entropy when Page-ing M Theory Dual of Thermal QCD above Tc at Intermediate Coupling, [arXiv:2207.04048[hep-th]]. [24] H. Geng, L. Randall and E. Swanson, BCFT in a Black Hole Background: An Analytical Holographic Model, JHEP 12 (2022) 056 [arXiv:2209.02074[hep-th]]. [25] M. Afrasiar, J. K. Basak, A. Chandra and G. Sengupta, Reflected Entropy for Communicating Black Holes I: Karch-Randall Braneworlds, [arXiv:2211.13246[hep-th]]. [26] A. Karch and L. Randall, Locally localized gravity, JHEP 05 (2001) 008 [hep-th/0011156]. [27] A. Karch and L. Randall, Open and closed string interpretation of SUSY CFT’s on branes with boundaries, JHEP 06 (2001) 063 [hep-th/0105132]. [28] A. Almheiri, R. Mahajan, J. Maldacena and Y. Zhao, The Page curve of Hawking radiation from semiclassical geometry, JHEP 03 (2020) 143 [1908.10996]. [29] S. Ryu, T. Takayanagi, Holographic Derivation of Entanglement Entropy from AdS/CFT, Phys. Rev. Lett. 96, 181602 (2006) [arXiv:hep-th/0603001]. [30] T. Hartman and J. Maldacena, Time Evolution of Entanglement Entropy from Black Hole Interiors, JHEP 05 (2013) 014 [arXiv:1303.1080[hep-th]]. [31] O. Aharony, O. DeWolfe, D.Z. Freedman and A. Karch, Defect conformal field theory and locally localized gravity, JHEP 07 (2003) 030 [hep-th/0303249]. [32] H. Geng and A. Karch, Massive islands, JHEP 09 (2020) 121 [arXiv:2006.02438[hep-th]]. [33] H. Geng, A. Karch, C. P. Pardavila, S. Raju and L. Randall, Information Transfer with a Gravitating Bath, SciPost Phys. 10 (2021) 5, 103 [arXiv:2012.04671[hep-th]]. [34] H. Geng, A. Karch, C. P. Pardavila, S. Raju and L. Randall, Inconsistency of islands in theories with long-range gravity, JHEP 01 (2022) 182 [arXiv:2107.03390[hep-th]]. [35] R. X. Miao, Massless Entanglement Island in Wedge Holography, [arXiv:2212.07645[hep-th]]. [36] K. Ghosh and C. Krishnan, Dirichlet baths and the not-so-fine-grained Page curve, JHEP 08 (2021) 119 [arXiv:2103.17253[hep-th]]. [37] G. R. Dvali, G. Gabadadze and M. Porrati, 4D gravity on a brane in 5D Minkowski space, Phys. Lett. B 485 (2000) 208 [hep-th/0005016]. [38] C. Krishnan, V. Patil and J. Pereira, Page Curve and the Information Paradox in Flat Space, [arXiv:2005.02993[hep-th]]. [39] A. Almheiri, T. Hartman, J. Maldacena, E. Shaghoulian and A. Tajdini, The entropy of Hawking radiation, Rev. Mod. Phys. 93, no.3, 035002 (2021) [arXiv:2006.06872 [hep-th]]. [40] C. Krishnan and V. Mohan, Interpreting the Bulk Page Curve: A Vestige of Locality on Holographic Screens, [arXiv:2112.13783[hep-th]]. [41] I. Akal, Y. Kusuki, T. Takayanagi and Z. Wei, Codimension two holography for wedges, Phys. Rev. D 102, 126007 (2020) [arXiv:2007.06800[hep-th]]. [42] R. X. Miao, An exact construction of codimension two holography, JHEP 01 (2021) 150 [arXiv:2009.06263[hep-th]]. [43] S. Choudhury, S. Panda, Entangled de Sitter from Stringy Axionic Bell pair I: An analysis using Bunch Davies vacuum, Eur.Phys.J. C78 (2018) no.1, 52 [arXiv:1708.02265[hep-th]]. [44] S. Choudhury, S. Panda, Quantum entanglement in de Sitter space from Stringy Axion: An analysis using α vacua, Nucl. Physic. B 943 (2019) 114606 [arXiv:1712.08299[hep-th]]. [45] S. Choudhury et al, Circuit Complexity From Cosmological Islands, Symmetry 13 (2021) no. 7, 1301 [arXiv:2012.10234[hep-th]]. [46] S. Choudhury, Entanglement negativity in de Sitter biverse from Stringy Axionic Bell pair: An analysis using Bunch-Davies vacuum, arXiv:2301.05203[hep-th]. [47] P. J. Hu and R. X. Miao, Effective action, spectrum and first law of wedge holography, JHEP 03 (2022)145 [arXiv:2201.02014]. [48] H. Geng, A. Karch, C. P. Pardavila, S. Raju, L. Randall, M. Riojas, and S. Shashi, Jackiw-Teitelboim Gravity from the Karch-Randall Braneworld, Phys.Rev.Lett. 129 (2022) 23, 231601 [arXiv:2206.04695]. [49] H. Geng, Aspects of AdS2 Quantum Gravity and the Karch-Randall Braneworld, JHEP 09
(2022) 024 [arXiv:2206.11277[hep-th]]. [50] N. Ogawa, T. Takayanagi, T. Tsuda and T. Waki, Wedge Holography in Flat Space and Celestial Holography, [arXiv:2207.06735]. [51] N. Engelhardt and A.C. Wall, Quantum Extremal Surfaces: Holographic Entanglement Entropy beyond the Classical Regime, JHEP 01 (2015) 073 [1408.3203]. [52] N. Ogawa, T. Takayanagi, T. Tsuda and T. Waki, Wedge Holography in Flat Space and Celestial Holography, Phys. Rev. D 107, 026001 [arXiv:2207.06735[hep-th]]. [53] A. Strominger, The dS/CFT correspondence, JHEP 10 (2001) 034 [hep-th/0106113]. [54] J.M. Maldacena, Non-Gaussian features of primordial fluctuations in single field inflationary models, JHEP 05 (2003) 013 [astro-ph/0210603]. [55] A. Karch and L. Randall, Geometries with mismatched branes, J. High Energ. Phys. 2020, 166 (2020) [arXiv:2006.10061[hep-th]]. [56] J. M. Penín, K. Skenderis and B. Withers, Massive holographic QFTs in de Sitter, SciPost Phys. 12, 182 (2022) [arXiv:2112.14639[hep-th]]. [57] K. Hashimoto, N. Iizuka, and Y. Matsuo, Islands in Schwarzschild black holes, J. High Energ. Phys. 2020, 85 (2020) [arXiv:2004.05863[hep-th]]. [58] G. Yadav and N. Joshi, Cosmological and black hole islands in multi-event horizon spacetimes, Phys. Rev. D 107, 026009 (2023) [arXiv:2210.00331[hep-th]]. [59] S. Chapman, D. A. Galante, E. D. Kramer, Holographic Complexity and de Sitter Space, J. High Energ. Phys. 2022, 198 (2022) [arXiv:2110.05522[hep-th]]. [60] G. W. Gibbons and S. W. Hawking, Cosmological event horizons, thermodynamics, and particle creation, Phys. Rev. D 15, 2738. [61] O. Y. Kupervasser, Grandfather Paradox in Non-Quantum and Quantum Gravitation Theories, http://dx.doi.org/10.4236/ns.2014.611079. [62] J. H. Baek and K. S. Choi, Islands in Proliferating de Sitter Spaces, [arXiv:2212.14753[hepth]]. [63] J. Maldacena and A. Milekhin, Humanly traversable wormholes, Phys. Rev. D 103, 066007 (2021) [arXiv:2008.06618[hep-th]]. This paper is under CC 4.0 license. available on arxiv

Multiverse in Karch-Randall Braneworld: Acknowledgements and References

FTC v. Amazon Court Filing, retrieved on Sep 26, 2023, is part of . You can jump to any part in this filing . This is part 1 of 80. HackerNoon’s Legal PDF Series here A. Amazon's First-Party Retail And Third-Party Marketplace Business Units 67. Amazon's First-Party Retail And Third-Party Marketplace Business Units Amazon began as an online bookstore in 1994 and rapidly expanded into new product categories: first DVDs and CDs, then electronics and toys, and then nearly everything. In 2020, Amazon sold almost (redacted) unique products across virtually every conceivable category to U.S. consumers. 68. Amazon originally sold goods to shoppers by purchasing items wholesale and reselling them on its website. Amazon calls its wholesale suppliers "vendors." Today, Amazon continues to sell a wide range of products through this type of vendor-retailer relationship, from laundry detergent to sports equipment. 69. Amazon also sells its own private label goods. These range from devices like Amazon's Kindle e-reader or Ring doorbell, to consumer products like batteries sold under the "Amazon Basics" label, to products without any clear· Amazon affiliation, such as dietary supplements sold under the "Revly" label. 70. These two components, vendor-retailer and private label, make up Amazon's first-party retail business unit, which Amazon refers to collectively as Amazon "Retail." 71. Amazon also runs what it calls its "Marketplace," where other companies can sell products directly to shoppers through its online store. Amazon calls third-party companies that sell on Amazon "sellers," and refers to sales by sellers as "Marketplace" sales. 72. Amazon charges sellers four primary fees to sell on its Marketplace. First, Amazon requires sellers to pay a selling fee, which can be a monthly fee or a fee for each item sold. Second, Amazon charges all sellers a commission or "referral fee" based on the price of each item sold on Amazon. Third, Amazon charges sellers for the use of Amazon's fulfillment and delivery services. Forth, Amazon charges sellers for advertising services. While Amazon also charges sellers. As a practical matter, most sellers must pay these four fees to make a significant volume of sales on Amazon. 73. Amazon estimated that in 2022, it would take (redacted)% of all sales revenue earned by sellers who use its fulfillment service. 74. The Marketplace accelerated Amazon's growth by allowing it to exponentially expand the selection of products on Amazon without having to carry the risks of unsold inventory. Sellers, who range from small businesses that offer a single product to multinational firms that sell thousands of products, ultimately bear that risk. As of the first quarter of 2021, there were over (redacted) active sellers on Amazon's U.S. Marketplace. 75. Amazon touts to its investors that sellers on the Marketplace are "a key 20 contributor to the selection offered" to Amazon shoppers. Sellers offer a huge variety of items for sale, from laptop computers to harnesses for walking pet chickens, complete with bowtie. In 2020, sellers offered more than (redacted)% of the unique items available for sale on Amazon. Sellers' products make up a growing majority of Amazon unit sales- 60% in the second quarter of 2023, up from 55% in 2021. 76. Amazon's online superstore unites its Retail and Marketplace rums, with products intermixed and presented to the public simultaneously and side-by-side. To a shopper browsing on Amazon, there are no obvious differences between the types of listings, nor is there a way to regularly shop for products sold only by Amazon Retail or Amazon Marketplace. 77. Amazon has achieved unprecedented scale. In 2021, goods worth more than (redacted) were sold through Amazon's U.S. online store. That amount is larger than the 2021 gross domestic product of (redacted) countries. 78. Amazon achieved this astonishing scale in part by combining its Retail and Marketplace arms. Amazon's product selection includes popular· and frequently pm-chased items and a "long tail" made up of an immense variety of less-frequently purchased products. Products offered by sellers on Amazon's Marketplace contribute substantially to that "long tail." More generally, Amazon’s sellers dramatically increase Amazon’s product selection, which draws more shoppers to Amazon, which, in turn, attracts more sellers. 79. Sellers have also made the Marketplace enormously profitable for Amazon. Amazon's internal documents show that profits from its U.S. Marketplace totaled more than (redacted) in 2021-nearly (redacted)% of its total reported net income for that year. Continue Reading . Here About HackerNoon Legal PDF Series: We bring you the most important technical and insightful public domain court case filings. This court case 2:23-cv-01495 retrieved on October 2, 2023, from is part of the public domain. The court-created documents are works of the federal government, and under copyright law, are automatically placed in the public domain and may be shared without legal restriction. ftc.gov

A Closer Look at Amazon's Growing  E-commerce Monopoly

THE APPOINTMENT TO THE 'BEAGLE.'

The Voyage of the Beagle by Charles Darwin, is part of the HackerNoon Books Series. You can jump to any chapter in this book here . PREFACE PREFACE I have stated in the preface to the first Edition of this work, and in the Zoology of the Voyage of the Beagle, that it was in consequence of a wish expressed by Captain Fitz Roy, of having some scientific person on board, accompanied by an offer from him of giving up part of his own accommodations, that I volunteered my services, which received, through the kindness of the hydrographer, Captain Beaufort, the sanction of the Lords of the Admiralty. As I feel that the opportunities which I enjoyed of studying the Natural History of the different countries we visited, have been wholly due to Captain Fitz Roy, I hope I may here be permitted to repeat my expression of gratitude to him; and to add that, during the five years we were together, I received from him the most cordial friendship and steady assistance. Both to Captain Fitz Roy and to all the Officers of the Beagle I shall ever feel most thankful for the undeviating kindness with which I was treated during our long voyage. 10 This volume contains, in the form of a Journal, a history of our voyage, and a sketch of those observations in Natural History and Geology, which I think will possess some interest for the general reader. I have in this edition largely condensed and corrected some parts, and have added a little to others, in order to render the volume more fitted for popular reading; but I trust that naturalists will remember, that they must refer for details to the larger publications which comprise the scientific results of the Expedition. The Zoology of the Voyage of the Beagle includes an account of the Fossil Mammalia, by Professor Owen; of the Living Mammalia, by Mr. Waterhouse; of the Birds, by Mr. Gould; of the Fish, by the Rev. L. Jenyns; and of the Reptiles, by Mr. Bell. I have appended to the descriptions of each species an account of its habits and range. These works, which I owe to the high talents and disinterested zeal of the above distinguished authors, could not have been undertaken, had it not been for the liberality of the Lords Commissioners of Her Majesty's Treasury, who, through the representation of the Right Honourable the Chancellor of the Exchequer, have been pleased to grant a sum of one thousand pounds towards defraying part of the expenses of publication. I have myself published separate volumes on the 'Structure and Distribution of Coral Reefs;' on the 'Volcanic Islands visited during the Voyage of the Beagle;' and on the 'Geology of South America.' The sixth volume of the 'Geological Transactions' contains two papers of mine on the Erratic Boulders and Volcanic Phenomena of South America. Messrs. Waterhouse, Walker, Newman, and White, have published several able papers on the Insects which were collected, and I trust that many others will hereafter follow. The plants from the southern parts of America will be given by Dr. J. Hooker, in his great work on the Botany of the Southern Hemisphere. The Flora of the Galapagos Archipelago is the subject of a separate memoir by him, in the 'Linnean Transactions.' The Reverend Professor Henslow has published a list of the plants collected by me at the Keeling Islands; and the Reverend J. M. Berkeley has described my cryptogamic plants. I shall have the pleasure of acknowledging the great assistance which I have received from several other naturalists, in the course of this and my other works; but I must be here allowed to return my most sincere thanks to the Reverend Professor Henslow, who, when I was an undergraduate at Cambridge, was one chief means of giving me a taste for Natural History,—who, during my absence, took charge of the collections I sent home, and by his correspondence directed my endeavours,—and who, since my return, has constantly rendered me every assistance which the kindest friend could offer. DOWN, BROMLEY, KENT, June 9, 1845 About HackerNoon Book Series: We bring you the most important technical, scientific, and insightful public domain books. This book is part of the public domain. Charles Darwin (1997). The Voyage of the Beagle. Urbana, Illinois: Project Gutenberg. Retrieved October 2022, from https://www.gutenberg.org/cache/epub/944/pg944-images.html This eBook is for the use of anyone anywhere at no cost and with almost no restrictions whatsoever. You may copy it, give it away or re-use it under the terms of the Project Gutenberg License included with this eBook or online at www.gutenberg.org , located at https://www.gutenberg.org/policy/license.htm l.

PREFACE

Noom helps you lose weight. We help you get a job at Noom. In today’s article, we’ll show you one of Noom’s hard SQL interview questions. We’re getting into the habit of choosing the hard for you. That’s probably not bad. If you manage to get through these questions, then the medium and easy level questions will be a piece of cake for you. data analyst interview questions A piece of cake we’re not discouraging you from eating. That’s Noom’s business as a fitness and weight loss subscription-based app. Our mission here to make you fit but only in terms of your SQL coding skills. is The interview we will cover is an excellent example of using and in a more advanced way, which includes writing subqueries. JOINs aggregate functions We’ll go through all the explanations step-by-step to make them easy to understand. If things get too complicated, you can always help yourself with our video tutorial that tackles the same question. https://youtu.be/5Lpbw71xR3o Noom Data Analyst Interview Question Here’s the question we’ll show you how to answer: Link to the question: https://platform.stratascratch.com/coding/2033-find-the-most-profitable-location To find the most profitable location, the business wants to compare the average sign-up duration and the average transaction amount for each location by taking a ratio between the two. They expect you to provide a table outlining each location, the average duration, average transaction amount, and ratio. The result should be sorted from the highest ratio to the lowest. Now, it wouldn’t be wise to just jump to writing a code and hope you’ll get to the solution somehow. Strategy is important, the same as your SQL knowledge. The strategy here includes a framework for solving this and other SQL data analyst interview questions. Solution Approach Framework to Solve (Noom) Data Analyst Interview Question We will use the three-step framework that will help you to take a complex problem and simplify it into few steps. If you’re our regular reader, you’re probably familiar with it. For those of you who are new to this or need a refresher, the three steps are: Exploring the dataset Writing out the approach Coding the solution First, you need to understand the dataset. This means understanding columns in the tables, their data types, and what the data really represents. Also, watch out for the traps hidden in data which could lead to considering the edge cases when writing the solution. When you’re done with this step, you should outline the steps you will take to solve the problem. No, you’re not coding yet! You’re only writing out your approach as sentences or pseudo code. What you do here is create a skeleton for your solution, and the code will add flesh to it. And the last step you probably hardly waited for is: start coding! It’s time that we showed you how this framework works on the Noom data analyst interview question. 1. Exploring the Dataset You’re given two tables: and . signups transactions The first table is a record of the sign-ups and has the following columns. Some of the important things to note are: column signup_id – we will assume this is the table’s primary key columns signup_start_date and signup_stop_date – formatted as datetime column plan_id – represents the plan type and is formatted as an integer column location – shows the city of the user, and the values can repeat You wouldn’t normally have a possibility to preview the data in the interviews. But since we do have, why not use this option? Here’s sample data from the first table. It is not that clear what the sign-up start and end date mean. Are they the dates when the customer registered on the platform/left it or the date when they subscribed to a plan/ ended the subscription? When in the interview, this is the perfect chance to pose these questions in the interview. We don’t have this possibility, so we’ll assume the start and the end dates show when the customer subscribed and canceled their plan. The second table, , contains these columns. transactions We can take up the following from this. column transaction_id – the table’s primary key column signup_id – the same column as in the first table, which means this is a foreign key column transaction_start_date – this date is, too, formatted as datetime column amt – should be an amount relevant to the transaction Take a look at the table’s preview. How do the two tables work together? Understanding this will basically unveil how Noom works. When the customers sign-up, they are assigned a unique signup ID (column signup_id), and an entry is recorded in the table. This record also includes the dates they signed up for their plan and canceled it (columns signup_start_date and signup_stop_date), the type of plan they subscribed to (column plan_id), and their city (column location). signups As Noom provides its services to the customer and the customer pays it, the transaction occurs. This transaction is logged in the table. There, each transaction gets a unique id (column transaction_id) that references the customer’s signup ID from the first table (column signup_id). There’s also a date (column transaction_start_date) and the amount charged for the transaction (column amt). transactions For subscription-based businesses like Noom, the customer is typically charged on a regular basis, e.g., monthly. What does this mean for the records in the question dataset? You should expect multiple transactions per signup. In other words, there is a relationship between the and the table: one customer can have multiple transactions. signups transactions Check this with your interviewer! The counterpart to the interviewer on our platform is writing a simple code to check what we just said. Run the code to see that there are multiple entries per signup ID. SELECT 
    signup_id, 
    COUNT(transaction_id) AS num_transactions
FROM transactions
GROUP BY signup_id
ORDER BY 2 DESC; Going back to how the subscriptions work, when the customer decides to end their subscription, this is reflected in the update of the column signup_stop_date in the table . signups 2. Writing Out the Approach This Noom data analyst interview question asks you to show the location, average duration, average transaction amount, and a ratio of these two averages. Now, the averages are not immediately available to you. So before showing the final output with a ratio, you should calculate the average duration and transaction amount per location. Here are the steps to do that and get to the solution. 1. Calculate average duration per location Duration is the difference between the sign-up start and end date. In business terms, this is a customer’s lifetime. You can find all the columns for this calculation in the table. signups 2. Calculate the average transaction per location To calculate the average transaction per location, you’ll need to use both the and table. transactions signups These two tables can be joined via the common column signup_id. 3. Join the two calculated tables You need both averages in the same table to calculate the ratio. Using the INNER JOIN is safe because both calculated tables will have the same locations. 4. Calculate the ratio Now that all the required data is in one table, you can calculate the ratio. The formula is: 5. Sort the results from the highest to lowest ratio To sort the output, use the ORDER BY. It is recommendable to think about the edge cases while writing out the coding approach. For this question, the edge case might be how to account for the active users, i.e., those who haven’t ended their Noom subscription. How do you write such a query, and does this edge case impact the interpretation of the results? To answer that, it’s crucial to uncover how the system records the sign-up stop dates for active customers. There are two possibilities: 1. The sign-up stop dates are blank for active customers. If this is the case, the steps written above would be erroneous. To avoid this, you should first filter rows where the sign-up stop date is not null, then do the calculations. That way, you’re restricting your analysis only to customers with an established lifetime. 2. A proxy date is used for the active customers’ stop date. If the current date is set up as a proxy date, then the sign-up stop date is updated daily. In that case, the average duration also changes daily because the duration of the active users increases. This is problematic because a customer who signed up yesterday will have a duration of one day, which is a misrepresentation of the customer’s lifetime. We recommend you restrict your analysis to current customers or a historical performance to avoid misrepresentation. Now that you have all the steps written out, the edge cases considered, and everything checked with the interviewer, you can start coding. We see from the table preview that the sign-up stop dates are there for every customer. So we’ll write the code assuming the table contains only the historical data. signups 3. Coding the Solution This framework part simply translates the above steps into an SQL code. 1. Calculate average duration per location First, find the difference between the start and stop dates. Then, use the AVG() function to get the average duration per location. SELECT location,
       AVG(signup_stop_date - signup_start_date) AS mean_duration
FROM signups
GROUP BY location; Remember that we noticed both dates are in the datetime format. That’s why we can directly subtract them. This query’s output shows all the customers’ locations and the average duration for each location. 2. Calculate the average transaction per location This step doesn’t require pre-calculation. All data is already available; you only need to join the two tables. SELECT location,
       AVG(amt) AS mean_revenue
FROM transactions t
JOIN signups s ON t.signup_id = s.signup_id
GROUP BY location; These are again locations, but with the average revenue instead of duration. Now that you have these two averages, you can build your target output. 3. Join the two calculated tables These two tables will be two subqueries joined by INNER JOIN in the FROM clause of the main SELECT statement. SELECT dur.location,
       mean_duration,
       mean_revenue
FROM
  (SELECT location,
          AVG(signup_stop_date - signup_start_date) AS mean_duration
  FROM signups
  GROUP BY location) AS dur
JOIN
  (SELECT location,
          AVG(amt) AS mean_revenue
  FROM transactions t
  JOIN signups s ON t.signup_id = s.signup_id
  GROUP BY location) AS rev 
ON dur.location = rev.location; The code output has almost everything you need in the final output. You have all the locations and averages in one table. Now you have to use them to calculate the ratio. 4. Calculate the ratio The ratio is simply the average revenue divided by the average duration. Additionally, convert the division result to a float to get the decimal numbers. SELECT dur.location,
       mean_duration,
       mean_revenue,
       mean_revenue/mean_duration::float AS ratio
FROM
  (SELECT location,
          AVG(signup_stop_date - signup_start_date) AS mean_duration
  FROM signups
  GROUP BY location) AS dur
JOIN
  (SELECT location,
          AVG(amt) AS mean_revenue
  FROM transactions t
  JOIN signups s ON t.signup_id = s.signup_id
  GROUP BY location) AS rev 
ON dur.location = rev.location; The output is the same as in the previous step, except this one has a ratio per location. Now the output only has to be sorted the right way. 5. Sort the results from the highest to lowest ratio The question tells you to sort the output in descending order by ratio. Just add the ORDER BY clause as the last row of the above code. SELECT dur.location,
       mean_duration,
       mean_revenue,
       mean_revenue/mean_duration::float AS ratio
FROM
  (SELECT location,
          AVG(signup_stop_date - signup_start_date) AS mean_duration
  FROM signups
  GROUP BY location) AS dur
JOIN
  (SELECT location,
          AVG(amt) AS mean_revenue
  FROM transactions t
  JOIN signups s ON t.signup_id = s.signup_id
  GROUP BY location) AS rev 
ON dur.location = rev.location
ORDER BY ratio DESC; By writing this, you’ve written the solution to Noom’s question. Your analysis shows that the highest revenue per day comes from Rio De Janeiro. The lowest ratio is in Luxembourg. Also, you can see the highest revenue is made in Mexico City, but it is spread out over a longer duration. Conclusion We hope you enjoyed solving this Noom data analyst interview question! We believe it really showcases how interviewers like to use familiar SQL concepts, such as data aggregation and JOINs, to make questions more difficult. Once you internalize the steps for solving the SQL questions and realize that you should use subqueries in this case, writing code becomes more manageable. All the heavy lifting has been done when analyzing the given dataset and formulating your coding approach. If you liked this Noom question, you could also try and solve another similar problem by Noom here → . Noom SQL Interview Questions Also published . here

Solving Noom's Data Analyst Interview Questions

Founders at Work: 150+ YCombinator Founders’ Stories

[Photo by on ] rawpixel Unsplash A repeatable sales model builds the platform to scale, but it can take experimentation and intensive research before you hit on one that’s truly sustainable. Here’s how to do it. If your business-to-business (b2b) company’s revenue generation is built on converting a few random cold calls into prospects and/or selling the same stuff to the same customers over and over again, it’s time to do something different. You’ll know that you’ve created a scalable sales model when: You can add new hires at the same productivity level as the entrepreneur or the sales leader. You can increase the sources of your customer leads on a consistent basis. You have a sales conversion rate and revenue that can be forecasted consistently. The cost to acquire a new customer is significantly less than the amount you can earn from that customer over time. Customers get the right products in the right place and at the right time. The harsh reality is that the average U.S. company loses about 50% of its customer base which means creating a path forward that must include a plan for repeatable, sustainable b2b sales is no longer a luxury — it’s a must-have. every year, Here are four ways to start doing this today: Define and design your authentic purpose. Every company needs to pin down “why we do what we do.” That’s the company’s North Star, guiding every aspect from recruitment to customer management to product development and sales. A strong purpose drives growth and profitability. For instance, an investment in the (a list of the world’s 50 highest-performing companies) over the past 10 years would have been 400% more profitable than an investment in the S&P 500. Stengel 50 In order to achieve sustainable success, companies must repeatedly reexamine their sense of purpose and make sure the organization serves it well. An authentic and inspiring purpose allows for: A constant, consistent sense of focus A strong emotional engagement both within the company and with its customers and partners Continuous, pragmatic innovation Sales and marketing experts often talk about “unique selling propositions,” or “USP,” which as the “factor or consideration presented by a seller as the reason that one product or service is different from and better than that of the competition.” defines Entrepreneur A company’s authentic purpose gives rise to its USP. When a business has a clear vision, it’s easier to create products and services of value. Revlon founder Charles Revson, for instance, always used to say that he sold hope, not makeup. Start right now by examining your USP. Differentiation comes from packaging your know-how (i.e. your intellectual property) into repeatable products and services that solves critical customer problems. Take an honest look at your current sales process. “You can’t fix what you don’t know is broken,” is a quote found on motivational posters and mugs, and it’s very relevant for B2B companies that want repeatable sales, but that don’t know how to go about getting them. Take an honest look at what you’re doing now, including the last 7–10 deals that closed. Where did the customer come from? What steps were taken to close the deal? How did the customers interact with your company? How long did it take? How much time elapsed between each of those steps? Use the answers to analyze your process and ferret out the gaps (i.e., a lead nurturing and closing process that takes too much time, or not enough regular customer touchpoints). Then, come up with a plan that addresses these issues as a first step in the right direction. Start right now by assessing your current sales process, asking yourself the above questions, and honing your process in a way that better meets customers’ needs while also contributing to your firm’s bottom line. Energize your customer renewal and order upsell process. B2B companies have a stable of customers that they sell the same stuff to over and over again. In many cases, customers don’t even knowthat they could be buying more (and different products/services) from you because they have Unless he’s visiting your frequently-updated (uh-hem!) website on a regular basis, for example, that electrical contractor probably doesn’t realize that your distribution firm recently added kitting services to its lineup. Someone has to tell him, and that step should be part of your firm’s order upsell approach. no idea that you carry them. An often-overlooked aspect of the sales cycle, upsells and renewals are both strategic sales processes that help you grow revenue and gain more market share. Ignore this aspect of your B2B business and it will quickly fall prey to the statistics (50% of buyers exiting annually) and a host of competitors that are pretty good at bundling products, switching up their offerings, and upselling goods and services. Start right now by coming up with a list of additional products and services that can be upsold to customers who are already buying from your firm on a regular basis. Show-and-tell customers that you care about their businesses. Every B2B company is operating in a world where just “providing” products and services isn’t enough to create a sustainable sales channel. Where companies in the past may have been able to get away with putting their needs (e.g. revenue growth) ahead of their customers’ needs (e.g. current state and readiness), this attitude just doesn’t cut it anymore. To truly become your customers’ trusted advisor and partner — and to keep them coming back for more and referring your firm to others — you have to care about their business as much as you do yours (if not more than). When clients pick up on this, their loyalty levels rise exponentially and everyone wins. Start right now by reaching out to a handful of customers to ask them what their biggest pain points, and then think of three ways to either directly or indirectly help them address these issues. Copyright © 2018 by Faisal Hoque. All rights reserved. . . . . . I am an . Founder of and other companies. Shadoka enables entrepreneurship, growth, and social impact. Author of “ ” (McGraw Hill) and “ ” (Motivational Press). Follow me on Twitter @ . entrepreneur and author SHADOKA Everything Connects — How to Transform and Lead in the Age of Creativity, Innovation and Sustainability Survive to Thrive: 27 Practices of Resilient Entrepreneurs, Innovators, and Leaders Faisal Hoque Use the Everything Connects leadership app and Suvvive to Thrive resiliancy app for free.

How To Make B2B Sales Sustainable

AdBank Introduction With the, almost, global adoption of the Internet, digital marketing has greatly surpassed traditional methods and has now become of one of the fastest growing industries in the world. The huge expanse of the worldwide web and sheer number of ad spaces available make the system prone to fraud and abuse. In order to combat these issues AdBank uses blockchain technology to provide complete transparency for transactions carried out on digital advertising platforms. In an industry worth an estimated $223.74 dollars, as much as 20%-50% (with some sources even estimating up to 75%) of that money is taken by middlemen, in this case those who operate search engines, ad networks, ad agencies, brokerages, affiliate programs, and media conglomerate. This system exists because publishers have no direct contact to advertisers, and collectively the two parties have no leverage over the middlemen. With very few concrete ways of validating views claimed by ad networks, the opportunity to commit ad fraud is not only tempting, it’s extremely easy to avoid detection. And because these anti-fraud detection systems are relatively easy to evade, there is little inventive for ad networks to spend valuable resources to tackle this issue. Most ad fraud occurs when owners of websites, social media channels or a popular public profile purchases views and likes. Bots trick websites into identifying them as a human user so they can manipulate the viewing figures, without being detected. This practice occurs on a remarkable scale, with companies such Google and Facebook even turning a blind eye to suspicious activity that may indicate bots imitating humans to commit ad-fraud. The current fraud detection systems must struggle to fight a constant battle against hackers who continually update their code to evade exposure. AdBank, however, utilizes its powerful AI to uncover abnormal behaviour that might indicate fraud, and take the necessary steps to shut down the malicious programs behind these hit inflation attacks. As technology improves so too does the intricacy of scams developed by fraudsters. New platforms such like the infamous Methbot developed by Russian hackers Ad Fraud Komanda (AFK13), which was created from the ground up to evade detection, can use unique approach to avoid the authorities. AFK13 did this by creating a network of over 250,000 URLs spread across 6,000 fake domains to rack up between 300,000 and 500,000 fake videos views in just one day. The AdBank platform would have easily detected the Methbot, and saved both advertiser and publisher millions of dollars. AdBank Overview. How it works… AdBank is an advertising ecosystem built on Ethereum. The open source technology and publicly available API will allow third parties to build custom modules that will contribute to a secure universal platform designed to manage online advertising services funded by the AdBank token. In addition, the adoption of blockchain technology integrated with intuitive AIs, allows for heightened security protocols that promise to greatly reduce the instances of ad fraud. Traditional fraud-detection systems are only designed to operate within the network it was developed for. AdBank’s system will utilize the blockchain, together with ad databases, ad images, user logs and even the rendering of web pages, to provide the most advanced supervised and unsupervised artificial intelligence with enough data to detect behaviour typically associated with fraudulent advertising activity. Once an anomaly is detected a case is raised and sent for inspection by human analysts to confirm if the transaction/s is fraudulent. The technology is able to detect a wide range of fraud techniques, below are just a few: Webpages failing to render all expected ads Catch unexpected shifts in traffic Mass selling of tokens, and selling profits quickly Fraudulent app and other digital products The system logs the necessary meta data of transaction and makes them available to the anti-fraud systems and analytics. The ecosystem consist of several layers, each powered by the AdBank (ADB) token. The core services will be developed as an interface between the systems to allow the products and solutions to be constructed in transitional ways. The ADB tokens will each represent an ad, or group of ads. Publishers then sell the ads through real time bidding, charging the highest bidder for their services in ADB tokens. Publishers can then chose to store the tokens, cash out, or use them for the purchase of the analytics package. And because all transactions on the blockchain are accessible by any/all users, the figures presented in the analytics are guaranteed to be genuine. Tokens can also be purchase outright. Users can also participate in reviewing fraud reports by signing up for the End-User Program through which they will be reimbursed for their time in tokens. Another useful feature allows users to download and install a browser plugin that suppress ads on their favourite sites for a small fee. In this case, the fee covers the cost an advertiser would have paid them, should an ad have been displayed. By offering a way to suppress ads, something that most people general hate, AdBank believes the public, as well as advertisers and publishers, will be more likely to adopt the technology quickly., Due to the tremendous scale of converting all ad networks to use AdBank tokens, the company will execute an innovative roll-up strategy to acquire existing ad networks. Acquiring the ad networks, creating the analytics package and anti-fraud system will be the first stages of development before the product is rolled out to the public. The team aims to launch the AdBank Network Ad Platform in March 2018, and acquire existing networks in May 2018. Valuable Information Adbank (ADB) Coin Name : 1,000,000,000 Total Supply : 510,000,000 Circulating Supply : 1 ETH = 7,500 ADB Pre Ico Price : 1 ETH = 7,500 ADB, 1 ADB = 0.0465 USD (0.00003 ETH) Ico Price : Who can use and benefit from AdBank technology ? AdBank digital advertising ecosystem stands to benefit both the advertiser and the publisher by connecting them via the blockchain platform and removing the need for expensive middlemen. As a result anyone using the Internet will also benefit from the system as it gives them some control over the ads displayed on their screen. The system also serves as a useful tool for companies that are now, after receiving disappointing results from pay large sums to ad networks, cutting digital marketing budgets and creating its own team to bring the process in-house. Paid likes and views and provide a the quickest and easy way to compete with companies that have a larger digital footprint, and thus the demand for ad networks is high. But despite the demand, venture capitalist are still cautious to invest in the development of ad networks because they too are afraid to compete with Google. AdBank offers a solution to this problem; publishers get paid in tokens to display ads, advertisers pay in tokens to have an ad displayed, but since the middlemen are removed from the process, the rates are much better. Some companies may also wish to hire the middlemen as an in-house team to manage their ads through AdBank. Team Jon Gillham, Founder & CEO Jon has co-founded a successful digital asset acquisition firm and has over 10 years of digital marketing experience. He has owned over 6,000 advertising websites, and has a depth of knowledge from both the advertisers and publishers sides in the digital media space. Jon previously held the position of Project Manager at Exxon Mobil (Imperial Oil) based on his background in mechanical engineering. Chiron Bramberger, Co-Founder & CTO Chiron has had over 17 years of experience deploying tech-focused client solution implementations and has worked with many Fortune 100 companies. Through the creating exclusive portfolios worth over 2 million dollars, and developing software such as creating General Motors’ first fully integrated vertical marketing platform, his previous clients include Toyota, Google, NASA, FBI, and Groupon, among others. Chiron is highly experienced in technologies such as : Unix, Linux, Windows, Mac OS X, SQL, SEO, CVS, SVN, GIT, Mercurial, Electronic Engineering, CNC / CAD / CAM. Development: C, C++, Objective-C, iOS, PHP, Java, .Net, ASP, ActionScript, MySQL, Python, Ruby, HTML/XHTML/CSS/AJAX, JavaScript, jQuery, RFC, Web Apps, Mobile Apps, AWS, OpenStack, Visual Basic, Fortran, COBOL, 6502 Assembler, Neural Networks Training, and SR&ED. Kelsey Cole, Co-Founder & CBO Kelsey is responsible for the brand’s image and oversees areas such marketing, advertising, design and PR. Prior to co-founding Adbank, Kelsey was named one of the Top 30 Under 30 during her time as head of PR at Revlon. She has also launched and worked with many high profiles brands such as Bill Tai, Richard Branson’s Extreme Tech Challenge., L’Oreal, Garnier, Red Bull, Juicy Fruit, Tesla, and TIFF. Leon Pereira Co-Founder & CCO Leon provides support to a wide range of stakeholders including employees, shareholders, influencers, the Adbank and crypto communities, and the wider public. He oversees the overall strategy as well as the execution of customer service and community management. Prior to AdBank Leon cofounded the XRP Exchange, Vietnam’s first exchange for buying and selling Ripple, and as a result became known as the ‘God Father of Ripple’. Angelo Dodaro Co-Founder & CMO As a successful marketing agency owner (Multivitamin Media) with experience personally running campaigns that earn tens of millions of dollars for his clients, Angelo brings an advertiser’s perspective to the tea, and is responsible for brand management, marketing communcations in advertising and PR, market research, sales management, product development, distribution channel management, pricing and customer service. Before joining AdBank he has created digital assests for Tesla Motors’ launch of the Model X in Canda, and as also collaborated with pulishers such as Elle Magazine and Canadian Living. , Himanshu Pandey Lead Developer Senior Blockchain Developer A blockchain developer with expertise in ethereum, bitcoin, and smart contracts. William Carrol UX / UI Designer Oversees the design for the Adbank platform and user dashboard. Narcis Bejtic Industry Outreach Coordinator Handles all token purchase coordination, SAFT agreements, accounts receivable and payable and oversees all administrative duties at Adbank. Natalie Slaven, CPA, Office Manager Brian Park Director of Business Development Rahul Singh Smart Contract Security Expert Shikhar Srivastava Smart Contract Developer Malaya Tripathi Full Stack Developer & Server Security Ravi Arya Full Stack Blockchain Developer / Security

REVL

revl.com

-- employees

Since n.d.

COMPANY RANKING

REVL

EVERGREEN INDEX #8756

Representing this company? Click here to claim and customize this page!

REVL WIKI

Apply to get your Tech Company News Page live on HackerNoon.com today!

REVL

revl.com

-- employees

Since n.d.

COMPANY RANKING

REVL

EVERGREEN INDEX #8756

RELATED COMPANIESRANK

STORIES ABOUT REVL

Representing this company? Click here to claim and customize this page!

REVL WIKI

Apply to get your Tech Company News Page live on HackerNoon.com today!