Sql group by sum jobs

...deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app 4) gitlab Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

I am seeking a talented illustrator who has a knack for creating engaging cartoon-style illustrations. This project involves creating illustrations for a children's book targeted at the age range of 0-4. Key Project ...Scheme: As for colors, I envision pastel colors to set the right mood and tone for the story. The illustrations should be gentle and soothing to the eyes, reflecting the typical sophistication of pastel colors. Ideal Skills: - Proven experience in cartoon-style illustration - Proficiency in using pastel colors - Prior experience in illustrating children's books, specifically for the 0-4 age group Your portfolio showing your past works in line with these requirements would be greatly appreciated. Looking forward to witnessing how your creativity could br...

...Investigate the potential of lithium tantalate: The main goal of this research is to assess whether lithium tantalate could serve as a cost-effective and efficient alternative material to the ones currently in use. - Academic audience: Given the nature of this project, the target audience for the final output will be academic researchers. Therefore, the content and analysis should be tailored to this group. - Presentation slides: The final deliverable for this project will be a set of presentation slides. These should be clear, concise, and visually engaging. Ideal skills and experience: - Strong research capabilities: The freelancer should demonstrate a proven track record of conducting thorough and insightful research. - Technical knowledge: A solid understanding of materials...

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product s...

...final stages of development, and we need a group of engaged users to participate in a 14-day closed test. Your task will be to find and recruit at least 20 testers who will opt-in and actively use the app during this period. Responsibilities: Identify and recruit a minimum of 20 testers. Ensure testers are engaged and provide feedback over a 14-day period. Monitor the progress and participation of testers. Provide support to testers if they encounter any issues during the testing phase. Collect and organize feedback from testers for our development team. Requirements: Proven experience in recruiting participants for beta tests or similar projects. Strong communication skills to effectively engage potential testers. Ability to manage and motivate a group of testers. Famil...

I'm in need of a creative and experienced comedy content writer to help me produce humorous content for my YouTube channel. Specifically, I'm looking for content similar to 'FUN WITH TAVISHI'. Key Requirements: - Content: Create original, engaging and humorous content for YouTube shorts. The content should be suitable for a all age group. - Length: The shorts should be less than 2 minutes long. This means you should be able to deliver punchy, funny content within a short timeframe. it can be message type /emotional of story .it should be like below .

Project Scope * Overseeing the development of a new website for the Client; * Launching an e-commerce store within the new website; * Creating and optimizing meta descriptions and images for each SKU; * Aligning and enhancing the Client's marketing strategy; * Creating a 12-month marketing calendar; * Collaborating with the website development team and internal IT and marketing teams; * Ensuring the project is completed within the agreed timeline and budget. Proposal Working remotely with on-site presence for the initial project kick-start 16th to the 27th of May 2024 and with on-site presence half way or towards the end of the project (dates to be discussed). Fee is $25,000 per month. Initial period projected to be 3 calendar months from the 16th of May 2024 to the 16th of August 2...

Project Scope * Overseeing the development of a new website for the Client; * Launching an e-commerce store within the new website; * Creating and optimizing meta descriptions and images for each SKU; * Aligning and enhancing the Client's marketing strategy; * Creating a 12-month marketing calendar; * Collaborating with the website development team and internal IT and marketing teams; * Ensuring the project is completed within the agreed timeline and budget. Proposal Working remotely with on-site presence for the initial project kick-start 16th to the 27th of May 2024 and with on-site presence half way or towards the end of the project (dates to be discussed). Fee is $25,000 per month. Initial period projected to be 3 calendar months from the 16th of May 2024 to the 16th of August 20...

Hello, We are F12Design, a platform where customers and designers come together and collaborate on graphic design projects. We would like to build an interactive dashboard to make the workflow simple and effective. Here are a few things on our mind: Languages - (Please free to suggest your own) Backend - PHP, jQuery, and SQL Frontend - HTML, CSS, and JavaScript For Real-time Demo/Example - Please sign up for and check their dashboard ########################################################## Social Login/Create account (Separate customer and Designer Login) ########################################################### Customer Dashboard Order Handling -------------- Past Orders Order Requirements (Quiz* and additional comments) Order Updates Order Delivery Date Order Tracking

I'm looking for an experienced illustrator with a particular knack for creating captivating cartoon-style artwork. The illustrations are for a children's book targeted towards 2-4 years olds. The pro...essence of more than 6 characters in a manner that is visually exciting and engaging for young children. Ideal Skills / Experience: - Proven experience in illustrating children’s books - Proficiency in producing high-quality cartoon style art - Ability to create a distinct look & feel for a diverse array of characters - Understanding of what engages and appeals to children in the 2-4 years age group. The goal is to make a book that not only entertains but also catalyzes imagination and curiosity in this young audience. A portfolio featuring previous works in ...

I'm searching for a professional who is proficient in SQL coding specifically for MySQL database design. PowerShell scripting or similar would also be beneficial. This is a basic level project taking existing Local government procedures and converting them into SQL based processes. An example of which would be creating a import procedure for traffic count data that is presented in a text format (example attached) Ideal Skills: - Experienced with MySQL Database Design - Well-versed in SQL coding - Ability to simplify complex instructions - PowerShell for anything not possible in SQL This project will demand creativity and intelligence to design procedures that simplify data entry processes. Please only bid if you can offer solutions according to the...

...development specialist to take our retail business to the next level, focusing on market research, sales strategy, branding, and marketing. Key Requirements: - Proven experience with market research, sales strategy development, and brand and marketing planning in the retail sector. - Comprehensive understanding of the young adult (18-35) demographic and how to effectively target and engage with this group. Your responsibilities will include: - Conducting thorough market research to guide our business strategy. - Developing a targeted sales strategy to appeal to the young adult demographic. - Crafting a branding and marketing plan that resonates with this demographic. - Implementing and monitoring the success of these strategies, making adjustments as necessary. Skills and exp...

A complete set of Construction Documents (including civil, structural, architectural, MEP, landscape and interior design) for 2 residential structures to be located on 2 adjacent lots. 1 will be used as a private residence and the other an assisted living group home. Architect must be able to stamp drawings. Images of the client's taste are provided to assist with design requirements. More images of interiors can be provided upon request.

Simple design of a large ⭕ or large sphere with a silhouette of a group of people inside. The sphere is resting on a palm of a hand.

...I am sure there are some things missing here but feel free to add your input. I do think this should give you a somewhat decent idea. Affiliates can sign up from CF Website or by invitation. (email) Affiliates have portal they can see activity  Post Training Materials  Marketing Materials  Post messages to “group.” CF has ability to send group emails to all affiliates CF has ability to Block/Remove Affiliates Links they use for sales generation tracks which Plan Package their client signed up for. Affiliate receives a commish based on:  Sale with Demo but no Training provided by Affiliate  Sale with Demo and no Training  No Demo, No Training Lead only Ability to create Sales reports for each Affiliate so that CF can issue Commish checks We ...

...for the ad: Script for the ad - for the subtitles The order of Reels I shot: Script: Reel: Action: Camera zooms out from hairline and I wink Line: This might sound crazy… but I’ve make over 4.5M by just using a small group to turn strangers into loyal high paying clients Reel: Action: Falling into a couch or bed or chair. Line: This might sound crazy… but I’ve make over 4.5M by just using a small group to turn strangers into loyal high paying clients You may believe I've lost my marbles, but... Reel: @7thavenueco/video/7226387202740210986?lang=en&q=couch&t=1715440562156 Action: Throw cushions on couches Line: This might sound crazy….. Reel:

i have Indicator tradingview code i need to fix the jason message to send alert in telegram group fit with cornix

I'm looking for a freelancer who can take the annual billing data from my personal business and create a professional, neat invoice from it. Key Details: - Final Format: The final invoice should be in PDF format. - Summary: I'd like the invoice to include a summary of the total income generated over the year. The summary should be kept simple and straightforward with a total sum, without the need for categorization or a monthly breakdown. Ideal Skills: - Strong attention to detail: The invoice should be well laid out and error-free. - Graphic Design: Experience in adding logos and making documents look professional is a plus. - Familiarity with accounting and invoicing: Some knowledge of these areas will be beneficial for understanding the context and importance of th...

...program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are, in order: Shipment, Rush order, Mo...

Jazba AI looking for Fullstack developer/AI developers/Blockchain developers who can build me a cutting-edge Web3 marketplace, integrated with AI capabilities, to cater for a broad spectrum of users. Key Skills & Experience: - Proficiency in Python, Angular.JS, , and experience in Machine Learning and AI. - Knowledge of Blockchain technologies like Solana and Ethereum. - Experience with Smart contract integration, Decentralized storage, and Tokenization of assets. - Ability to implement Generative AI and integrate with ChatGPT 4.0. - Proficiency in Third-Party Integrations like CRM, Lead Generation, Social Media, and Slack. - Previous experience with Android and iOS integration will be beneficial. The marketplace should be designed with the following features: - Smart contract integr...

I need assistance with scraping data from a website and delivering it in an Excel file. The specifics of the project are as follows: I am looking for a person who will conduct scraping sessions for our business on a regular basis. Desired skills are knowledge of screen-scraper software, sql, Someone with Python knowledge will be better. Willing to follow instructions. Not cramped up with other jobs or other side hustles. Need to have solid internet connection. Expected work takes 5-10 hours per week, once fully trained. Must be responsible. Able to accept PayPal. - The source of the data is a website. This means the freelancer needs to have experience in web scraping. - The data should be delivered in an Excel file. Proficiency in handling and formatting data into Excel is a mu...

...projects based on expertise, and project flow (usually 1-5 projects per month per lancer depending on work quality, ethics, expertise and behavior). Pay : We are all developers, no end clients, and get a fixed budget from our managers to perform tasks. Everybody knows what time which task takes, and payments are fixed accordingly by the managers. 1. Single App projects : INR1500-2000 2. 2/3 Apps (user, vendor, delivery boy) projects : INR3000 3. Custom projects on lump sum based on work (given only to devs who are part of rebranding team from time to time as extending functions on scripts, or complete projects according to requirements) Must have : 1. Honest - budget is never increased beyond what is mentioned above. lancers who quote one amount and then ask more, w...

Data Specialist: The Data Specialist is responsible for pr...information that is in databases, organizing and assembling the information so that teams can make decisions using data. Responsabilities: > Access database. > Create dashboards and analysis according to the demand of the business areas. > Update and automate dashboards that need frequent updating. > Provide suggestions of improvements in business areas. Requirements: > Mandarim is a must > SQL > Office Package > Database usage At Shein, we believe that diversity is the force that drives innovation. We are committed to creating an environment where all voices are heard, valued and respected. All our vacancies are inclusive for people with disabilities, women, black people, LGBTQIAPN+ com...

...Key requirements: - Establish a Local Area Network: The main goal of the project is to set up a local network that ensures a seamless connection among the devices for file sharing purpose. - Secure File Sharing: The network should be configured in a way that file sharing is secure and only accessible to the authorized devices. - Minimal Device Connectivity: As the network is intended for a small group of less than 10 devices, the setup should be simple and efficient without compromising security. Ideal Skills: - Networking Expertise: A deep understanding of LAN setups and configurations is crucial. - File Sharing Knowledge: Experience in setting up networks for efficient and secure file sharing. - Security Awareness: The ability to ensure the network is set up securely and in a ...

Hello, I need a quick fix for my DNS server running on a 2012 R2 system. The major problem encountered is that I'm unable to access my shared files. However, I can ping the IP addresses of the devices hosting these shared files. An RPC Error is shown and some Group Policy issues occur when trying to access these files. • I need someone who understands DNS thoroughly. • Experience with Server 2012 R2 is necessary. • Knowledge of RPC errors and Group Policy is required. Would appreciate quick and effective troubleshooting. Thank you!

I need a skilled professional who's an expert in Azure Data Factory (ADF) development, SQL, Power BI, and ADF monitoring. Key Tasks: - Creating data pipelines - Building data transformation workflows - Integrating with SQL databases Power BI Usage: - Visualizing data through interactive dashboards - Creating data reports and analytics - Real-time monitoring and alerts ADF Monitoring: - Tracking data pipeline performance - Monitoring data integration processes - Setting up alerts and notifications for job failures. Ideal Skills and Experience: - Expertise in Azure Data Factory (ADF) development - Proficiency in SQL, Power BI, and data visualization - Strong background in monitoring ADF performance - Experience setting up real-time alerts and notifications - Pr...

I am in need of an experienced Social Media Manager who has a commanding expertise in Instagram and TikTok platforms. Your role will primarily revolve around: - Community Engagement: You should be able to constructively engage with our Gen Z audience base (aged 18-24), fostering a sense of communi...encouraging active participation. - Monitoring and Moderation: A key part of your job will be to keep any forms of harassment at bay - we want our platforms to be a safe, positive space for every user. Ideal applicants should have a proven deep understanding of Gen Z trends, interests, and communication styles on Instagram and TikTok. Previous experience in handling social media for this age group will be a crucial advantage. Looking forward to attracted, informed bids from suitable c...

...accounts to forward customers personal group message to x amount of other groups. Installing a subscription based plan with certain amount of groups to choose from. It needs a user panel with a GUI for me to work with Example: Subscription plan A: forward message to 500 groups Subscription plan B: forward message to 1000 groups Subscription plan C: forward message to 2000 groups Step 1) make the program login to telegram accounts through web Step 2) join groups with the account Step 3) forward automated messages from my channel to other groups with interval every 20minutes to 1hour simultaneously functionalities: - option with interval from 20minutes to 1 hour - ability to add multiple telegram account to forward messages - ability to see from which group account got ...

I'm seeking an independent ASP.NET developer based in India with at least 5 years of experience, strong C# programming skills, and familiarity with SQL Server and Asp.net core. Your English skills will be crucial as direct communication with me is required. Key Responsibilities: - Develop a robust business management system leveraging ASP.NET - Implement user authentication and authorization features - Integrate appropriate APIs to enhance system functionality Ideal Candidate: - Minimum 5 years experience in ASP.NET development - Proficient in C# programming and SQL Server - Familiarity with Asp.net core - Experience in developing business management systems preferred - Strong communication skills for client call Please note that this project is only open to Indian-ba...

I'm seeking a robust analysis that delves into the dietary habits leading to obesity in children and adolescents. Key Project Components: - Deep exploration into the various diet tendencies prevalent in this age group that might lead to obesity. - Comparative analysis of different diets and their impact on weight - Data-driven insights into preventive measures. Skills and Experience: - In-depth knowledge in nutrition and dietetics - Vast experience in health research, in particular, childhood obesity - Strong analytical and interpretive skills.

I'm looking for a talented designer to create a logo for my company, Shire Group. The style should be traditional, with a color palette that includes green. It could be only green or green with other colors. Shire Group is a construction and real estate development company specializing in traditional stone construction homes and development of agricultural neighborhoods. Our homes are natural, built in a traditional style, and connected to the outdoors, durable, and oriented to community interaction. The people who buy our homes value living in community, participating in the production of food, enjoy homesteading, appreciate historical architectural styles, and enjoy the outdoors. Many of the people interested in our homes are religious and appreciate the religious art...

...who can readymade Rummy game for Android and iOS. Also there should be feature in admin panel from I can host tournaments. - Development for both Android & iOS: - The game should be developed for both these platforms, ensuring that it's optimized and functions seamlessly on both. - Target Audience: - The main demographic is young adults aged between 20-35. The game should cater to this group in terms of design, features, and overall user experience. - Game Type: - The Rummy game I'm looking to develop is based on Indian Rummy. Players should be able to enjoy the complexities and strategies that come with this variant. Ideal skills for this project include: - Proficiency in Unity - Strong knowledge of game development for both Android and iOS - Experienc...

I'm in need of a talented copywriter to craft authentic and engaging social media posts specifically targeting young adults (18-24). The main aim is to boost engagement with our followers. Ideal skills and experience for this job include: - Proven track record in creating compelling social media content - Understanding of the 18-24 age group and their interests - Experience in boosting engagement metrics - Ability to maintain brand voice and message consistently across platforms

... The role may also involve programming. Key points: - Coaching: I need 1/1 coaching via Teams on Data Analysis & Data Visualization within Azure Analytics - Programming: If the opportunity arises, the candidate could get involved in programming using SQL - Proficiency: I consider myself at an Intermediate level with Azure Analytics Ideal Skills and Experience: - Proficient in Azure Analytics: You should have a strong understanding of Azure Analytics, specifically in Data Analysis and Data Visualization - SQL Programming: Experience with SQL is a must as you may be involved in programming for this project - Teaching or Coaching Experience: Prior experience in teaching or coaching Azure Analytics would be advantageous - Strong Communication: The ability to clear...

I'm seeking a digital marketing expert to spearhead a social media marketing initiative for my business, with the primary aim of increasing brand awareness among professionals aged 25-40. Key responsibilities will include: - Developing a comprehens...on-brand content for various social media platforms - Executing the strategy with a focus on increasing brand visibility and recognition - Monitoring and reporting on the performance of the campaign, making adjustments as needed The ideal candidate should have proven experience in social media marketing and a strong understanding of how to effectively reach and engage professionals in the 25-40 age group. Experience in branding and an understanding of metrics and analytics in relation to social media marketing would also be hig...

A business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowl...technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a case-by-case basis. Experience in data warehousing and governance. Practical experience in enabling data usability, availability, and efficiency. Experience in data management, quality, metadata management, and modeling. Knowledge of database systems: MS SQL Server, Oracle, or another commercial RDBMS required, Snowflake, or other non-relational database desired. Knowledge of SQL. Experience with scripting languages, especially...

I'm in need of a skilled developer who is experienced with inventory management systems, report production, analytics, user access control, and Windows-based applications. This job involves maintenance of a warranty return tracking software, with specific attention to: -...considered a plus. The overriding purpose of this software is to track and manage warranty returns effectively. Ideally, you should have previous experience in software creation and maintenance for tracking and managing products. The purpose of this project would be Bug fixing and improvement of the software tool already existing. Required: Experience with ER Models architecture Experience with MS SQL server 2017 express as DBMS Experience with Python 3.8.3 and Tkinter GUI toolkit Experience with Powe...

I am in search of a seasoned web designer to create a series of corporate websites for my company group in Greece. Key Project Details: - The project involves designing multiple corporate websites, estimated between two to five in total. - The primary objective of these websites is to showcase our range of services and products to potential clients. Responsibilities: - Develop visually appealing and user-friendly corporate websites. - Ensure the websites are optimized for performance and are responsive across devices. - Incorporate our company's branding and design aesthetics into the websites. Ideal Skills and Experience: - Proven experience in designing corporate websites. - Understanding of UX/UI design principles. - Proficiency in working with web design tools and techn...

...Early Childhood Teaching expert who can assist me with creating a lesson plan centered around "Invitation to Play". Key Responsibilities: - Develop a comprehensive lesson plan: This should include a thorough outline of how to introduce the concept of 'Invitation to Play' to a group of young children. - Incorporate key teaching strategies: Strategies to keep the children engaged and interested in the lesson. - Consider different learning styles: Adapt the plan to cater to a variety of learning styles within the group. - Ensure age-appropriate content: The teaching materials should be suitable for young children. Ideal Freelancer: - Previous experience in Early Childhood Teaching: A solid understanding of teaching young children. - Exceptional Lesson P...

I'm looking for a freelancer with experience in setting up and customizing SafetyCulture auditing syste...experience in setting up and customizing SafetyCulture auditing system. Key Requirements: - Inclusion of OHS, Fire, and Equipment Safety aspects - Setup for 1-10 users - No integration with other systems needed Ideal Candidate: - Proficient in SafetyCulture auditing system - Experience with safety aspects like OHS, Fire Safety, and Equipment Safety - Ability to customize for a small user group - strong communication skills for clear understanding of needs and providing assistance. We will be working with SafetyCulture to be able to provide assistance in the setup, and support. I will also be providing a specification document with all requirements the syst...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

...priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that converts their answer (in one cell) to a score (in an adjacent, hidden, cell). The second formula involves summing (adding) the scores (easy), but then counting number of values 'summed', and dividing the total sum by the number of values counted. The objective is to write a formula that adds up the various scores, divides it by the number of answers provided (i.e., doesn't count questions they skip), and generates a total score. In the attached image,...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

...engage this specific group. - Brand Awareness Strategies: The goal of this campaign is primarily to increase brand awareness. Your skills in developing effective strategies to achieve this goal through email marketing are thus crucial. Skills and Experience: - Proven experience in email marketing and creating successful brand awareness campaigns. - Proficiency with email marketing and automation tools. - A solid understanding of the professional audience aged 25-45. - Strong creative and strategic thinking skills to develop effective brand awareness strategies. I'm looking for a seasoned professional who understands the intricacies of email marketing and has a proven track record in running successful brand awareness campaigns. Your ability to engage the 25-45 age grou...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I need a skilled WordPress developer to list custom posts by closest distance to the current users address, which has been added via an ACF Google Map in the user profile. The list of posts will appear on the users profile page which is set up in Each custom post already has a latitude and longitude as post meta using ACF. I just need help with extracting the latitude and longitude from the Google map in the user profile and sorting the posts according to distance from those coordinates. Ideal Skills and Experience: - Extensive experience with WordPress custom post types and custom fields. - Proficiency with Advanced Custom Fields (ACF) Google Map integration. - Prior experience implementing distance sorting on WordPress websites. This is an urgent project so I would

I'm in need of a proficient data analyst to perform group comparison analysis on my SPSS file. Key Requirements: - The purpose of this analysis is to compare different groups or variables (two). You'll need to identify the relevant groups and perform T-tests/ANOVA accordingly. - You'll be provided the data in SPSS file format, hence experience and a good understanding of SPSS is a must. Ideal Skills and Experience: - Proficiency in SPSS and strong statistical analytical skills. - Experience in conducting T-tests and ANOVA. - Ability to interpret and explain results in a clear and concise manner. Please bid if you have the relevant skills and experience for this task.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

I'm in need of a talented designer who can create a unique and illustrative logo for a WhatsApp group dedicated to providing support for individuals affected by long COVID. Key Points: - Logo Style: The logo should be illustrative in nature, with a creative concept that reflects the supportive and communal nature of the group. - Color Scheme: I am open to different color palettes, so there is flexibility for you to use your creative judgment. - Design Purpose: The aim of this logo is to convey a message of support and community. It should be able to resonate with individuals who are looking for a safe space to share, connect and receive support on this pressing health issue. Ideal Candidate: - A strong portfolio of previous logo designs, especially illustrative ...

..."GPT-Invoices" should be able to analyze invoices stored in a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoic...