...• SQL LIMIT • SQL TOP • SQL Subquery – Correlated and Uncorrelated • SQL EXISTS • SQL CASE • SQL DECODE • SQL AUTO INCREMENT • SQL Accessing Forwarding and Preceding rows (Lead & Lag) • SQL Window functions (Rolling windows, Cumulative calculations, Moving Averages) • Pivoting data • Hierarchical Queries • C...
...verifications needed to link to their Chelle Wallet where the ERC-20 tokens that were purchased from our ICO cabinet (for MVP). The database must be able to migrate new columns and/or rows as we scale the app up in Phase 2 where users will be able to convert fiat currencies and other cryptocurrencies like Bitcoin. The database must also keep information about
I need a script that imports to my database every row (product: name, price, description...) from a csv file. the ...file is kinda complicated in some columns (category column for example has hundrents of different option and needs to transform to whatever i need). File contain about 800.000 rows, i would like the proccess to take less than 3-5 hours.
...column named "order ID" that is used on both spreadsheets, it can be used to connect both spreadaheets and identify which row must be updated. The script should identify what rows were modified on spreasheet A and find the row on spreadsheet B that refers to the same order based on the value of the column "order ID". These two spreadsheets are separated
...have a solution in mind, but don't have time to do it properly. I have a small dataset of attributes for some items. Some items have common themes - so first I need help grouping those. This can be manually done, probably in 30 mins. (e.g. Item 1 = "Spa", Item 2 = "Spa Facilities" - common theme is "Spa") Next, I need you to mine the data to identif...
Hi I need a custom web based application to get hashtags and datas and pictures of desired instagram user...without using api [log ind for at se URL] database will be stored on [log ind for at se URL] stored data should be csv or similar [log ind for at se URL] pulled datas should be displayed online on preferred domain in Rows with one click .this is the first step of the project. Thanks
We grow plants in an indoor farm. There are several rows of plants in different rooms. Each row is on a different harvest schedule. Certain tasks must be completed prior, during, and after growing periods for each row of plants. The timing of these tasks depends on the particular plant being grown in that row. Often tasks from one row will overlap
... Quick Access Toolbar, Ribbon, Tell Me Box 2) Basic of Cells and Sheets e.g. Insert, delete, drag & drop cells or Fill, cut, copy, and paste functions. 3) Modify & Format Rows, Columns, Cells & Numbers 4) Working with Multiple worksheets 5) Creating simple and complex formulas (including nested functions) 6) Cell referencing: Relative & Absolute
I am looking for someone that can help develop a data capture method (internet based) t...program called [log ind for at se URL] we dont like the end report but like some things that the program can provide. Internet and computer based data capture... grouping of the pictures etc Attention to detail and good communications skills are a must.