Santiago Moresi

Generation

Tengo una base de datos donde quiero saber el porcentaje de clientes que hicieron compra en al menos dos sucursales. Tabla de la base dato que tengo que usar son 'clientes' y 'compra'

SELECT COUNT(cliente_id)/(SELECT COUNT(DISTINCT cliente_id) FROM compra) FROM compra GROUP BY cliente_id HAVING COUNT(DISTINCT sucursal_id) >= 2

Access all features through one powerful interface — lightning-fast, incredibly intuitive, and designed for productivity.

Generate

More than just a code generator. A tool that helps you with a wide range of tasks. All in one place.

Function from Description: Generate a function just by describing what is needs to do. Choose of many programming languages.
Text Description to SQL Command: Create a SQL command from a description.
Translate Languages: Translate code to any programming language.
Generate HTML from Description: Generate small HTML from Description.
Code to Explanation: Any code explained in plain english.
Fix invalid Code: To spot a missing character somewhere can be frustrating. This feature will help you to fix it.
Get Test for Code: This feature will help you to create tests for your code.
Class from Description: Generate a class just by describing what is needs to do. Choose of many programming languages.
Regex from Description: Create a regex from a description like "check for email".
Regex to Explanation: Create a plain english explanation from a regex.
Git Command from Description: Find the Git Command you are looking for from a description.
Linux Command: Get the linux command from a description.
Function from Docstring: Provide a docstring to generate the actual function.
Add typing to code: This feature will help you to add typing to your code.
Get Language from Code: Get the programming language from a code.
Time complexity: Get time complexity.
CSS from Description: Generate CSS from Description.
Meta Tags from Description: Generate Meta Tags from a Description.