Parent child tree sql query jobs

I've created codes using AI for the game doors, implementing two algorithms - Minimax and Monte Carlo Tree Search. I need a professional who can transform my work into a fully-fledged, web-based TD-Gammon board game. Key Requirements: - Bring to life the TD-Gammon board game based on my code - Integrate two AI algorithms: Minimax and Monte Carlo Tree Search - Implement an AI opponent with adjustable difficulty Critical Skills: - Proficiency in AI algorithms, particularly Minimax and Monte Carlo Tree Search - Experience in coding interactive games and board games - Ability to deliver high-quality web-based platforms Delivery: The final product should be a fully functional web-based game that accurately reflects the TD-Gammon concept.

I'm looking for someone experienced in running projects from GitHub repositories "" to assist me in setting up and running the demo-k6-operator project on my Mac machine. Your guidance should help me to understand how this project works, which is my primary goal. Key requirements: - Expertise in running and configuring projects from GitHub repositories on Mac machines - Solid understanding of the demo-k6-operator project - Ability to provide clear, detailed instructions and guidance for running the project on my machine - Patience and willingness to explain concepts to help me understand the project better The specific challenge we may face is that I'm using a Mac CPU that is NOT Intel, so experience with this kind

...and manage fee structures for different classes, including tuition fees, exam fees, and other charges. Allow for online payment processing with various payment gateways. Generate invoices, receipts, and financial reports. Communication Tools: Facilitate communication between teachers, students, and parents through messaging systems and announcements. Provide event calendars for scheduling exams, parent-teacher meetings, and other activities. Library Management: Catalog and manage library resources. Implement a check-in/check-out system. Provide search functionality for students and staff to find resources. Transportation Management: Manage bus routes, schedules, and transportation assignments. Track bus attendance and maintenance schedules. Inventory Management: Track school ...

I'm seeking a skilled graphic designer to develop a logo for my upcoming childcare center. Here's what I envision: - **Color Scheme**: The logo should prominently feature green and brown, reflecting a natural, nurturing environment. - **Imagery**: I envision the logo incorporating a tree or leaf as the central element. This will help convey a sense of growth, harmony, and safety - all important values for my center. I'm looking for a logo that's not only visually appealing but also resonates with parents and children. Ideally, it should be playful yet professional. If you have experience with childcare or education-related branding, that would be a definite plus. Experienced designers with a strong portfolio and a good understanding of brand identity are enco...

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?

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...

I'm in need of a sophisticated and luxurious logo design that can effectively represent my brand across various platforms. Key Requirements: - The logo should exude an elegant and luxurious aesthetic, appealing to both adult and child audiences. - It needs to be versatile, working well on both digital and print marketing materials, as well as my website. Ideal Skills: - Strong experience in minimalist design. - Background in creating versatile brand identities. - Previous work with logos that appeal to multi-generational audiences.

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

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 am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

I am looking to commission a print featuring an abstract palm tree island and a wave. The ideal candidate for this project would have the following skills and experience: - Ability to interpret and refine existing design concepts while incorporating their creativity - Keen eye for detail and aesthetic appeal Ive attached abstract prints for reference of style and colour, and 1 image of a wave and island.

...- Significant experience working with SAP Cloud ALM data sources - Proven ability to provide step-by-step instruction catered to a beginner - Patience and passion for teaching complex topics in a simple to understand manner I'm eager to learn, and I look forward to your bid. Let's delve into data together and create a powerful Grafana dashboard. We have an example blog here. I will use my laptop as a test mashine, for this POC. So that is where we will be working. So we have to work on a shared screen, where you guide me what to do, to make it work. If you are not ok with this, then

Logo for my new business. The company name is "Cedar & Spirit" this is a holistic business where we connect with the client's inner spirit/self. The vibe I'm going for is healing, holistic, loving and kind. I love the look and softness of the water colour look. The cedar tree is important as it connects us with our inner self, intuition and our higher self... I have attached a few pictures for inspiration... I'd like the files in PDF, PNG, and JPEG. A copy in each: white, black, and colour (all with no background)... I'm open to fonts but please ensure they are readable if they are cursive style. please keep colours to a minimum - using only branding colours. i'd also like to see some sketch drawings... My brand colours are in an image below ...

I'm seeking a talented professional to design a comprehensive business case for my technological solution in child protection. This document will primarily be used for presenting our business to potential investors and stakeholders. Most of the content has already been compiled and available to include. Collaborating with me will be required to build out and contextualise content where necessary. Essential skills and experience for the job include: - Business case design experience - In-depth knowledge of business case requirements and necessary inclusions - Shrewd understanding of investor and stakeholder expectations - Previous work on startup projects is a bonus - Communication Your task will involve developing an investment-ready business case that effectively communicate...

...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...

...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 invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

Our existing ...CGI script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

I'm looking for a creative mind to produce engaging 15-second product level vide...Example of what we're looking for: Here are the products we want videos built for

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

I have a simple design in Corel Draw and need it converted to Illustrator. This includes adding a cutline around the design. - I have two designs. Very, very simple. One is the tree. The other is 400 leaves that need to be cut. - The primary task is to convert the entire design from Corel Draw to Illustrator format. - The secondary task is to add a cutline around the design. This will serve as guidelines for future cutting of the file. - You will be required to work with precision, as the cutline needs to be accurate and well-aligned with the design. - Experience with both Corel Draw and Illustrator is essential. Ideal Skills and Experience: - Proficiency in Corel Draw and Illustrator. - Attention to detail for precise cutline implementation. - Experience with simple design con...

...reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex ...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Optimize database performance through indexing, query optimization, and other performance tuning techniques.  Develop and enforce data standards and best practices to ensure data integrity and security.  Provide technical guidance and mentorship to junior developers.  Troubleshoot database issues and provide timely resolution.  Stay up-to-date with the latest trends and technologies in database management and architecture. Skills and Qualifications  Bachelor's degree in Computer Science, Information Technology, or a related field. Master's degree preferred.  8+ years of total experience.  Minimum of 5 years of experience in database architecture and development, with a focus on Netezza and Oracle.  Proficiency in SQL and PL/SQL programming l...

...map renderer for creating an overhead map. The purpose of this map is visualization and analysis over a few acres. While I don't have a preferred software tool for the 3-D rendering, I encourage the use of a tool that best matches your expertise, such as SketchUp, AutoCAD, or 3ds Max. The map should have medium detail, capturing major landmarks and features without the need for detailing every tree or building. This includes topographic elements, key structures, and significant landscape features. Ideal Skills and Experience: - Proficiency in 3-D rendering software (SketchUp, AutoCAD, 3ds Max, or similar) - Experience realizing medium-detail overhead maps - Understands the balance between level of detail and clarity for visualization and analysis - Ability to deliver high-...

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm in need of a talented UI/UX designer who can create a layout similar to the CDC Milestone app for both iOS and Android platforms. Key Requirements: - Proven experience in designing engaging and interactive user experiences - Strong understanding of Apple's and Google's design principles and ...high-level requirements into beautiful, intuitive, and functional designs - Excellent communication and collaboration skills to work with the development team - Experience in designing educational apps is a plus, but not required Please note that the focus here is on creating a similar layout to the CDC Milestone app. This project does not involve the creation of any content or features specific to child development. The goal is to replicate the app's layout and stru...

As you know, Magento displays the lowest priced simple product associated with configurable products. we want the price of a specific child product to be shown. There are modules designed for this, known as configurable preselect, but I couldn't get it to work. Although there are settings in the module for category or listing display, the preselect feature that works on the product detail page does not work on the category page. Can you solve this problem?

I would like to update this theme in Hugo to make a website look like the one below. The homepage would list all folders in the parent directory under content and then click into the subdirectories showing the md files of each respective category. It’s a very well done website and I’m having a hard time making the theme work exactly as they have it. I believe the theme is out-dated and needs to be update. Here is the theme I want to implement: Website I want to mimic:

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

I am seeking a freelancer to help my elementary school-aged child with extracurricular activities that focus on skill development. The ideal candidate will have experience in creating fun and engaging activities that will challenge my child and help them improve their skills in various areas. Skills and Experience: - Experience working with elementary school-aged children - Ability to create and implement activities that focus on skill development - Strong communication skills to effectively communicate with both myself and my child - Knowledge of various extracurricular activities that can help develop skills - Passion for working with children and helping them reach their full potential

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your app...

...hide progressively: -This function would be added on besides the existing selecting and hiding function. Add the possibility to modify size and side of the lateral windows (Lexicon and Definitions): -The cursor would become a double-arrow when passing on the edge of the window and it could be resized. Showing children-objects without their parent: -Hiding the parent hides the children, but showing a child should only show the parent if the child is a label (suffix '.t' and '.s') Showing the bonus collections in the first pop-up when right clicking a structure in the 3D space -Instead of RMB>Structures>...; these structures would appear directly with the other options (Hide; Isolate;...) Advanced mission (Estimated...

...data analyst with proficiency in SQL and R for a comprehensive evaluation of a recently completed data analysis project. This project requires a review of SQL queries, R scripts, and database connections as detailed in a provided PDF. If you're ready to start right away and can deliver within 24 to 48 hours, please get in touch. Responsibilities: Conduct a thorough review of project requirements as specified in the PDF. Evaluate the accuracy and efficiency of SQL queries and R script implementations. Verify database connections and the effectiveness of data visualizations. Identify any discrepancies or areas for improvement. Deliver a comprehensive report detailing findings, issues, and potential improvements. Requirements: Demonstrated expertise in SQL...

...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer t...

...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...

I'm in need of a professional to optimize my PL/SQL code for better performance. The primary focus of this project is to enhance the overall efficiency of the code. Key Responsibilities: - Perform PL/SQL performance tuning to improve the execution speed of queries. - Implement bulk collect operations to enhance data retrieval efficiency. - Optimize the compilation of procedures for better code execution. I'm seeking someone with extensive experience in PL/SQL, particularly with performance tuning and bulk collect operations. Proficiency in procedure compilation optimization will be a bonus. Your expertise will play a crucial role in achieving the project's goals.

...skill tree. You'll need to ensure that this integrates smoothly with the other systems. - **NPC Skills**: The NPCs within our game possess unique skills that need to be effectively linked to the Skills System. This includes the implementation of a variety of AI skills . - **Class System**: Our game has distinct classes that heavily influence the Skills System. Each class should have its own unique skill tree. Additionally, we have a system in place where NPCs' clothing changes depending on the class they belong to. The project timeline is negotiable as I'd like to spend some time explaining the task given the progress already made. However, the ideal candidate should be able to commit to a reasonable timeframe. this project can be made in different parts...

...effectively combine data from a single table that consists of parent-child relationships. The main task for this script will be to focus on combining data from the parent-child and combining it onto 1 row each. Specifically, the required updates will involve: - Combining Parent and all children data onto same row - Taking DOB field and splitting into a Month field and a Year field - The end result should be a base where I can upload a new CSV and it outputs the desired result into a new table that I can download a csv from The ideal candidate for this role is someone well-versed with airtable scripting and data management, specifically having a strong knowledge of number fields. Your experience with manipulating parent-child data rela...

I'm looking for an AI/ML developer to work on a research and development project. The goal is to develop an AI module that can recognize a birds-eye view of a forest. The module will be tasked with: - Identifying tree species - Monitoring forest health - Counting trees - Measuring tree height The AI module will have access to various types of data to perform these tasks, including aerial images, satellite images, and drone footage. The desired level of accuracy for this AI module is moderate. The ideal candidate should have: - Strong AI/ML development background - Experience in image processing and recognition - Familiarity with working on forest/environmental monitoring projects would be a plus.

...engagement that currently features an obstructive tree. The tree in question is blocking the view us, and I want it removed. What I'm aiming to achieve, is for the space left by the tree to be replaced with an existing subject from the photo - a person. This may involve duplicating/cloning the subject to fill the space. I would also like the pole removed. So, the freelancer who undertakes this task should: - Have a good understanding and experience in photo manipulation - Be skilled in using software such as Adobe Photoshop (or similar) - Have a knack for making the end result look natural and seamless - Demonstrate attention to detail to ensure the continued quality of the photo. I expect a final product that appears as though there was never a tree...

I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in s...requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and res...

I'm looking for an experienced game developer who can create interactive web-based language games specifically desi...performance across various devices. - **Educational Game Design:** A background in designing educational games or content for children, with a focus on language learning. The goal of this project is to create a series of fun and educational language games that can be easily accessed and played by preschoolers on a web browser. The ideal candidate will have a passion for creating high-quality, child-friendly content and a strong understanding of early childhood todevelopment and language acquisition. The language is Aramaic and english we will provide the words and the translation and meanings Website already created recently just need to create a kids zone wi...

Contest Overview Premier Property Group is launching a contest to find a highly skilled and creative consultant to develop a complete brand identity for our new subsidiary. This contest will involve the creation of a new company name and logo. We aim to establish a distinct and memorable brand image that aligns with our vision and values while differentiating the subsidiary from the parent company. PLEASE READ!!!! We are looking for a company name and logo for the new subsidiary. Not a logo for Premier Property Group. We need a new company name and logo for the subsidiary Premier Property Group builds single-family and multi-family homes in the United States, primarily in the Southeast region. The market is characterized by growing demand for affordable yet quality housing, drive...

I'm seeking a skilled C# developer to create a software solution aimed at processing data from a Winsock for a wifi connected Weight Scale and get the reading and put in a Microsoft SQL database.

I'm looking for a skilled Unity UI designer with experience in creating child-friendly interfaces to design a menu UI toolkit for my Gold Miner game. Key Features: - Customizable Buttons: The menu should have buttons that can be easily customized. These buttons should be clear, colorful and appealing to a young audience. - Animated Background: An engaging, lively animated background will add an extra layer of interest and fun for the children. - Interactive Icons: The menu should include interactive icons, encouraging young users to explore and interact with different elements. Style: - The overall theme of the menu should be childlike and engaging. The design should be simple, playful, and easy to navigate. - The game is targeted at a very young age group (3-5 years old). Th...

I need a concise and informative PowerPoint presentation done on the Disabled Facilities Grant (DFG) in the UK. This will be presented in PPT and should run for 8 minutes, no AI: MAIN QUERY OF TASK: "The DFG team currently has a large backlog of cases, both children and adults, that need to be dealt with and processed promptly and efficiently. We will be undertaking a process review to enable us to achieve eliminate the backlog. What suggestion would you have to update the process, and the service, ensure HBC compliance, and ultimately customer satisfaction? Key Task: - Conduct Research: The main focus of this presentation will be the process review of the DFG application process in the UK. The ideal candidate should have a strong background in thorough research and experienc...